PDA

View Full Version : convert xls to csv large number problems



ermis1975
05-31-2010, 02:03 AM
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
05-31-2010, 03:31 AM
A csv file will not store number formats. It is a simple text file.

ermis1975
05-31-2010, 03:53 AM
So if I have a number with 13 digits why I cant make it csv? as tect chr.?

mdmackillop
05-31-2010, 04:08 AM
I don't have a problem with that. Can you zip and post sample files, Excel & CSV?

ermis1975
05-31-2010, 04:25 AM
I have one cell with a number 123456789012 after save as csv the number becomes 123457000000.

mdmackillop
05-31-2010, 05:35 AM
On my test I get
123456789123456

That's why I asked for sample files.