A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Teri,
To summarize this clearly for future reference and get straight to the point:
Excel preserves all digits of large numbers if
a) the cell is formatted as text before the number is entered,
b) the number is imported as text,
c) the number is preceded by an apostrophe.
Example file:
https://www.dropbox.com/scl/fi/7x90cf16smrf8wsc757d2/6073427.xlsx?rlkey=ivto4k0oqmpsl6ogp7u8glz4d&dl=1
Even small numbers with many leading zeros, displayed due to cell formatting, do not lose any digits when saved as CSV file!
Example file:
https://www.dropbox.com/scl/fi/qzqgr8p31xdwj3r97dp9e/6073427.csv?rlkey=wabl2v7qnmh946g4qiffmj2r8&dl=1
It is only when you open the CSV file in Excel that conversion occurs, causing digits to be lost! Check the file using Notepad, and you will see for yourself.
In newer versions, there is an option to disable this conversion during open. In older versions, you must import the CSV file, for example, using Power Query, and specify the data type for the column as "text."
https://support.microsoft.com/excel/keeping-leading-zeros-and-large-numbers
Andreas.