I have to export gross wages for the quarter for our Unemployment Wages report. My problem is that I am building a line with spacing specific, so I am building multiple text formulas to create my individual lines (actually in the group footer). My data automatically comes through to text as 99,999.99 and I cannout have any commas or periods within my result. How do I strip out the commas and periods or format the numeric data field to be general (no commas).
I can multiply my gross wages by 100 to eliminate the need for a decimal point, I think.
I can multiply my gross wages by 100 to eliminate the need for a decimal point, I think.