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 pupose of why I may want to export :smileyfrustrated:, may as well use Word)

Still waiting on this to be enhanced :smileyfrustrated:

Very frsutrating have to unmerge coloums and coloumn by coloumn or cell by cell convert text to number.

 

Is there a better solution?

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