Modify a column in CSV

Help Activities
, ,
1

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?

Thanks!
Angel

2

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

1 Like
3

Hello @ppr,

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

Thanks
Angel

4

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

5

Thanks! It worked:)

6

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