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...
PS....
jhbunce wrote: ``when I open this file in Excel, it appears to be rounding/truncating at 8 positions. I've increased the field size, but the additional values present in the .csv are not showing``
When you open a CSV file directly, initially the cells are formatted as General. If you increase, the width of the column, the General format still displays only 11 characters, including decimal point and any minus sign.
So, by default, 12.3456789012345 is displayed as 12.3456789 or with less precision.
But you should still see 12.3456789012345 in the Formula Bar.
And for that example, you can format as Number with 13 decimal places to see the full precision in the cell.