Hi ToMMie,

The longest integer you can input as a number is 15 digits.

--
Cheers
macropod
[MVP - Microsoft Word]


"ToMMie" wrote in message ...
I format the cell as custom type like 0000 0000 0000 0000 in order that the
number the user key in the cell 1111222233334444 (without space) will display
like 1111 2222 3333 4444 automatically.

But the problem is when I key in 1111222233334444 the last number always
becomes ZERO at all time like 1111 2222 3333 4440.

How can I fix that? Could you please help me?

Many thanks.
ToMMie