Hello -Thank you so much for looking into it. Per your suggestion I tried'Prepend/PostpendText' in RB. For some reason it did the opposite. I originally setformatting for this data block to remove scientific/text formatting. When Iadded single quote and refreshed the data block manually all numbers ...
Appreciate the suggestion!This data is a part of a bigger automated report. I am trying to avoid any manual manipulations and am looking for possible ways to adjust the formatting automatically most likely by excel formulas.Nat
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 f...