Converting 16 digit nr's to csv file

[ANDRE LE ROUX]

Hi

I need to save a file as .csv, the file contains a list of account numbers of 16 digits, and everytime I save it as a .csv file, it changes the last digit to Zero, how can I fix this.

Please Help

[rikkid]

Hi

This is happening because Excel complies with IEEE specification for calculating and storing floating point numbers.

The only way to show and store correctly is to format cells as text or put an apostrophe in front then you can have numbers up to 1024 characters displaying in excel.

Hope this helps.

[JosephP]

if the numbers are displayed with all 16 digits then the csv file itself will be fine but if you open it back up in Excel the program will convert the data to numbers and replace the last digit with 0. if you view the csv file in notepad you should see that it is actually saved correctly.