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

1 Reply

Looking for something else?

Related content

Importing Xero to Client Accounting

Tax payment advice to clients

Client Access to upload docs

Export Suppliers

CSV Import to Client Accounting

Connected Accounts: How to manage your account connections

Invoice paid by wrong client

EXPORT EMPLOYEE DETAILS