Scientific Notation Issues

[Guest]

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?

 

[JE McGimpsey]

Import the file using the Text Wizard, and in the third pane, indicate
the columns are Text rather than General.

 

[Pete_UK]

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

 

[Guest]

Excel precision upto 15 digits. In order to get exact numbers, you have to
format cell as text or precede with (') no quoute

 

[Guest]

Nailed it. Thanks.

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

 

[Pete_UK]

Glad it worked for you - thanks for feeding back.

Pete