automatically rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All I'm trying to do is enter in a 16 digit number into a a nuber formatted
cell. The last digit keeps reseting to zero. I'm not asking it to do any
rounding for me. All I want to do is see my 16 digit number the way I entered
it. No decimals, no fractions.
 
Excel has limit of 15 digits for numeric data. If you don't need to do any
calculations with your number then format the cell as text.

HTH
 
Not all 16 digit integers can be represented exactly in the binary format
specified by the IEEE standard (followed by almost all computer software).
Rather than explain why an entered value of 9007199254740993 immediately
changes to 9007199254740992, MS chose to (and clearly documented in Help)
restrict Excel to acceptign and displaying no more than 15 digits.

If your 16-digit number happens to be one that can be represented exactly,
then you can enter it using a formula such as
=900719925474099*10+2
but you cannot directly display it. The functions at
http://groups.google.com/group/microsoft.public.excel/msg/b106871cf92f8465
can be used to examine the actual values resulting from IEEE double
precision approximation to numbers.

As was previously noted, if you don't need to do math with it, then just
enter it as text.

Jerry
 
Back
Top