Forum Discussion

rohbrown's avatar
rohbrown
Experienced Cover User
6 years ago

Export from Client Accounting Report - Text to number

Does anyone have a quick, easy colution for convert the Client Accounting reports, when exported to Excel, all field come through at Text. They then need to be converted to Number (hmm, defeats the p...
Reports export
Mark_St's avatar
Mark_St
MYOB Staff
6 years ago

Hi rohbrown,

 

As you have mentioned, converting each cell in Excel to a number field is the solution.

 

As the reports are exported as text fields which is hard coded this can only be changed after exporting to Excel.

 

 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.