Numeric data is exported as text. Any chance the format can be changed to numeric?
A$ 4,400.00
-A$ 10.00
-A$ 2,500.00
Numeric data is exported as text. Any chance the format can be changed to numeric?
A$ 4,400.00
-A$ 10.00
-A$ 2,500.00
please search the forum before posting new questions. this has been discussed already a few many times.
this is related to excel and not Manager.
excel identifies the data as text due to the presence of currency symbol. just click on the column in excel and change to Number.
If you’re pasting into a pre-made template (e.g. if you run that report frequently, and just want to update the data), I think it will keep the formatting you set previously. So you should only need to do this once.