Modify a column in CSV

Dear all,

I download info from pdfs, and then i write it in .xlsx. After that, to account this information in the accountant system, i do need to change .xlsx to csv. The issue is that the account number to use is composed of 12 digits. When I convert the file from xlsx to csv, the column with the account number change to 5,72E+11, instead of 572000000000, so the system is unable to read the file.

How can I fix this issue?


give a try to reformat the column in excel with following activity:

1 Like

Hello @ppr,

I will try. Also, is this activity able to change amounts from format 15000 to 15.000,00?


it should do it, just have a research in excel on the format string

Thanks! It worked:)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.