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 the desktop app.
Any one else having this issue or have a solution?
Thanks.
Hey JS321,
Sounds like you’ve run into the numbers-exporting-as-text since the latest update. The good news is that there's a workaround for this. You need to highlight the cells or the whole column with those numbers, right click, choose ‘Format Cells.' Pop over to the ‘Number’ section, and hit OK. That should set things straight again!
Cheers,
Doreen
Hi Doreen,
Thank you for the feedback. This is what I've been doing. It is time-consuming as we do multiple exports across multiple companies. Any idea when/if this will be fixed?
Thanks
Hi JS321,
Thanks for letting us know how this impacts your month-end work especially when you’re juggling with multiple companies. Exporting reports into Excel so the numbers come through as text is the standard, so switching the cell format to ‘Number’ is the recommended way to view your figures properly. There’s not a fix for this since that's how exported reports work.
Cheers,
Doreen
Hi Doreen,
We have been using MYOB for years and this number to text issue only began last week. We have never before had to do the text to number conversion.
Thanks.
Hi JS321 , one possibility is that something has changed in your Office program. Try doing a quick repair.
Which reports are affected? Give me a couple of examples.
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 :-(
