View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Large integers in excel 2003 are rounded ?? Is this a BUG ?

A credit card number, like a phone number or even a house number, is
not a real number - these are codes or labels. You may do some simple
arithmetic on them like add 1 to a house number and you get the next
one in sequence, but would the number divided by 2 make any sense?

You have 15 digit precision in the mantissa, and can represent numbers
up to 10 E308 and down to 10 E-307 which is a very large range. If you
want 16 digit precision you have to treat the "number" as text.

Pete