Teri

Excel recognizes 15 digits of precision. Any thing after that is changed to a
0.

If you need a 15 digit number like a stock number or credit card number,
precede the number with an apostrophe.

This will return a text string, not a caculable number.


Gord Dibben MS Excel MVP

On Thu, 20 Apr 2006 13:37:02 -0700, Teri (nospam) wrote:

We did figure that out however we don't understand why it does it in the
first place. If you put symbols (-) or spaces or commas between number it
works okay. Any reason why the error after 12 digits?

Also another problem - when changing to Number format - the last digit typed
in changes to a 0 automatically when pressing Enter. 12345678901234567
(entered) changes to 12345678901234560. Any explanation?