Expand my Community achievements bar.

Report Builder keeps formatting numbers in Scientific/Text format

Avatar

Level 1

Hello -

In my reports I have to report on confidence level that uses decimal number, which is not standardized and can get very long. In the report the number of decimals higher than 13 decimals gets converted to Scientific/Text format. I can manually change these types of numbers to number/generic format, and if I refresh report manually RB keeps the number/generic format. However, the scheduled report keeps reversing the numbers back to the Scientific/Text format. I spoke to Adobe client care they said that this is an excel limitation as the cell should display no more than 11 digits in the General format. I tried formatting, formulas and was not able to find any solution yet. Do you have any suggestions for me? Thanks in advance!

10 Replies