Scientific Notation Issues
Nailed it. Thanks.
"Pete_UK" wrote:
Excel can only display 15 digits - the lower digits will be set to
zero. One way to overcome this is to treat the number as a text value.
Rename your .csv file to .txt and then in Excel use File | Open and
point to the file. The Data Import Wizard will automatically start,
giving you more control over how the fields are treated. In the first
panel click on Delimited, in the second panel click on comma, and in
the third panel you can highlight each field in turn and choose the
format - click on Text for your large numbers, then click OK.
Hope this helps.
Pete
On Sep 21, 5:36 pm, Matthew P. <Matthew
wrote:
I have a cell displaying 1.03E+15. It appears that Excel rounded the actual
number to the nearest ending zero. 1030604200755582, 1030604200755583,
1030604200755581 all now show up as 103060420075580. I am opening it as a
.csv
Any suggestions?
|