Weird Excel Issue

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
 
B

Barb Reinhardt

It's not wierd. It's expected. The number precision in Excel is 15 digits.
 
G

Gord Dibben

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
 
J

Joe Medford

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
 
D

Dave Peterson

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.
 
J

Joe Medford

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