Exporting numbers as text -Using Desktop App
Hi, Since the update this month, all our reports are exporting numbers as text into excel. I know it works correctly in the browser but all our custom reports for month end reporting is only on t...
Forum Discussion
Hi Mike,
I did consider that however when I called MYOB support, they also got the same result.
It is happening with any excel export so Trial Balance, GL etc. It doesn't matter if it's a custom or generic report either.
We use the Desktop App and only this seems to be affected. If I do an export from the online version, then its all good. Unfortunately, all our customs reports are on the desktop version which is why we're still on it.
Thanks JS321 . I've run a few such reports and the values in Excel are all formatted as numbers. (v2025.6).
Was clearing the cache suggested or attempted?
No, it wasn't. How do you do that on the Desktop App? The exports are not auto saved either, they just open as an excel file.
Hi JS321 , instructions for clearing the cache are here:
Clearing the AccountRight Cache | MYOB Community
It's a long shot but worth trying. It's usually for when there's some kind of data inconsistency.
Reports sent to Excel are based on Excel templates, and like any such file they then have to be saved.
Hi Mike,
I followed the processes and cleared the cache but still the same :-(
JS321 , have you considered creating an Excel macro to store in your personal workbook that would automate the text-to-number correction? If you wish, send me an example of a report which needs correction, my email address is on our home page (datawise.co.nz), and I'll set one up.
Hi Mike,
Thanks so much for all your suggestions. I can do a work around so that's okay, but I was hoping to get to the bottom of why this was suddenly occurring. Since you don't have the same issue, I'll check the MS Office angle.
