Weird Excel Issue

  • Thread starter Thread starter Joe Medford
  • Start date Start date
J

Joe Medford

When I take the following number 2481030076751701 and put it into excel, it
displays the number as 2481030076751700. I have the column formated as
number. Why is is changing the last digit, and how can I correct the
problem.
Thanks
 
Joe

Excel has a 15-digit precision for numbers.

Anything over that becomes a zero.

No way to force Excel to accept a real number over 15-digits.

If the number is a stock/part number or similar and you won't be calculating
with it, just preface with an apostrophe or pre-format the cell(s) to text
format.


Gord Dibben MS Excel MVP
 
Text Format does not work, when set to text it says E+15. I am storing
purchase information (reciept number), and I need the full number stored.
Stored and displayed number is wrong
Thanks
 
Gord suggested that you format the cell as Text first--then type in your data.

Changing the cell's format to text won't retroactively fix any existing value in
that cell.
 
That works. Thanks

Dave Peterson said:
Gord suggested that you format the cell as Text first--then type in your
data.

Changing the cell's format to text won't retroactively fix any existing
value in
that cell.
Click to expand...
 
Back
Top