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?

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




In article ,
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?

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?

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?

Glad it worked for you - thanks for feeding back.

Pete

On Sep 21, 5:56 pm, Matthew P.
wrote:
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?- Hide quoted text -

- Show quoted text -

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


"Matthew P." 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?