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