Losing last digit on 16 digit number

  • Thread starter Thread starter davee10
  • Start date Start date
D

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?
 
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?
Click to expand...

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
 
Back
Top