Losing last digit on 16 digit number

[davee10]

I am importing a figure of 16 digits into an excel file e.g.
4000000000000002 but it is showing as 4000000000000000

Is there a way to stop this happening?

 

[Ron Rosenfeld]

I am importing a figure of 16 digits into an excel file e.g.
4000000000000002 but it is showing as 4000000000000000

Is there a way to stop this happening?

16 digits exceed Excel's specifications (15 digit limit).

You'll need to import the number as TEXT. Depending on exactly how you are
importing the number into the file, you might be able to preformat the cell as
TEXT; precede the value with a single quote; or specify TEXT in the
Data/Text-to-Columns wizard.


--ron