Forum Discussion
Importing a .csv file to Excel. Not all decimals are present in Excel
I have a.csv file that, when viewing it via Notepad++, I can clearly see numbers in this file with as many as 10 decimal positions to the right of the decimal point. However, when I open this file in...
Did you find any solution to the problem? I have the same issue : if I open the CSV in NotePad I see all my decimals ( 2316500062.2316500062101, but once I open the CSV in Excel my last decimals become 0 - > 2316500062.2316500000000
That is unavoidable. 2316500062.2316500062101 has 24 significant digits. But Excel displays numbers only up to the first 15 significant digits (rounded), replacing any digits on the right with zeros (courtesy of JoeUser2004),
I actually already found a solution in the meantime. Instead of just opening the CSV file in EXCEL you use the button from the menu DATA -> click FROM Text / CSV
when the import window opens you must click : do not detect data types. This way excel imports all the data from CSV, with all the decimals.
Worked for my above example.