Rounding on Entry

F

Fellow Wanderer

When I enter "2446921240995606" in a cell formatted as a number
and hit enter, the last digit is altered to a zero. the result I get is
"2446921240995600".

Is there a way to keep it from being changed without formatting it as text?
 
B

barry

no there is not... excel only takes 15 digits for numbers.. after that.. no
choice but text..
 
J

Jerry W. Lewis

Not all 16 digit integers have exact representations in IEEE double precision
(used by Excel and almost all other software). 2446921240995606 happens to
be one that can be exactly represented. You can obtain that value as
=611730310248901*4+2
but it will display as 2446921240995610, since Excel displays no more than
15 digits. You can verify that it actually has the correct value by using my
functions at
http://groups.google.com/group/microsoft.public.excel/msg/b106871cf92f8465

Jerry
 
Top