Issue with numbers as text
I am having the below issue with a number as text. it needs to be displayed as text, for posting into another system.
in the attached, in IA local I am just using TEXT(ROUND('Investor Amount (Local)' * 100, 0) / 100) but as you can see on one line I get the number displayed in an odd format.
I have tried rounding all over the place and not sure how to rid of it.