convert xls to csv large number problems

[ermis1975]

I have a large number (13 digits) and when I save as csv from xls the number format is wrong and the numbers apears with zeros in the end.

[mdmackillop]

A csv file will not store number formats. It is a simple text file.

[ermis1975]

So if I have a number with 13 digits why I cant make it csv? as tect chr.?

[mdmackillop]

I don't have a problem with that. Can you zip and post sample files, Excel & CSV?

[ermis1975]

I have one cell with a number 123456789012 after save as csv the number becomes 123457000000.

[mdmackillop]

On my test I get
123456789123456

That's why I asked for sample files.