Export from Client Accounting Report - Text to number

Question

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?

mark_st · Answer

Hi rohbrown,
&nbsp;
As you have mentioned, converting each cell in Excel to a number field is the solution.
&nbsp;
As the reports are exported as text fields which is hard coded this can only be changed after exporting to Excel.
&nbsp;
&nbsp;

Forum Discussion

Export from Client Accounting Report - Text to number

Looking for something else?

Related content

Client Accounting - Create PDF

Accounts Right: Profit and loss by client

Accountants Office - Client Accounting Reports

Client Accounting - Assets reporting

Export Client Notes

client purchases history

CSV Import to Client Accounting

EXPORT EMPLOYEE DETAILS