Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Highlight Duplicate on entry | Setting up and Configuration of Excel | |||
How do I compare the entry in one cell against all other cells | Excel Discussion (Misc queries) | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
double-clicking a list entry | Excel Discussion (Misc queries) |