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
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.
