Forum Discussion

rohbrown's avatar
rohbrown
Trusted 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...
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