S
srichar
I am trying to enter a 16 digit number, like a credit
card number, and no matter what kind of formatting I try,
the 16th digit of the nunmber gets reset to zero!
Actually, this happens for the 16th digit and beyond as
well. i.e, the 17th, 18th, etc all get reset to zero no
matter what digit I entered. Which begs the question
whether this is a bug or is there is a upper number limit
that a cell can display? If its the latter, then thats
pretty dumb, since all I wish to do is just display this
number and not run any math operations on it! I tried
formatting it as text, or using a special format, etc..
and none of them worked.
Maybe I am missing something, but this was not a problem
in the pre-2003 versions.
System Config:
WinXP (with all the latest updates)
2003 Office,(with all the latest updates)
512ram
AMD 2400 CPU.
Thanks.
card number, and no matter what kind of formatting I try,
the 16th digit of the nunmber gets reset to zero!
Actually, this happens for the 16th digit and beyond as
well. i.e, the 17th, 18th, etc all get reset to zero no
matter what digit I entered. Which begs the question
whether this is a bug or is there is a upper number limit
that a cell can display? If its the latter, then thats
pretty dumb, since all I wish to do is just display this
number and not run any math operations on it! I tried
formatting it as text, or using a special format, etc..
and none of them worked.
Maybe I am missing something, but this was not a problem
in the pre-2003 versions.
System Config:
WinXP (with all the latest updates)
2003 Office,(with all the latest updates)
512ram
AMD 2400 CPU.
Thanks.