Rounding on Entry
 

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?

Rounding on Entry
 

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


"Fellow Wanderer" wrote:

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?

Rounding on Entry
 

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/micro...06871cf92f8465

Jerry

"Fellow Wanderer" wrote:

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?