Avatar

Level 1

Hello -

Thank you so much for looking into it. Per your suggestion I tried

'Prepend/Postpend

Text' in RB. For some reason it did the opposite. I originally set

formatting for this data block to remove scientific/text formatting. When I

added single quote and refreshed the data block manually all numbers turned

back into and scientific/text format. This is why I honestly think that

this is RB functionality issue and not Excel.

Thank you so much for your help! Also special thanks for showing me

the 'Prepend/Postpend

Text' in RB, I did not notice this functionality before.

Nat

After - this is how it looks like with the "prepended" single quote.

Before* - this is how the data looks like with the set formatting

(removing text/scientific formatting) refreshing *manually

On Thu, Sep 13, 2018 at 1:25 AM, hyderziaee <forums_noreply@adobe.com>