That is because Excel number precision only works to 15 digits. That last
one will get truncated whether you use a custom format or not.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"littlesword" wrote in message
...
I want to format a cell wherein spaces will be automatically added to the
numbers that I will type. The format should be like this 1111 2222 3333
4444.
I was able to make this format but the problem is, it always replace my
last
number to 0. For example, if I type 5462 5700 0123 4568 it would be
displayed
as 5462 5700 0123 4568. The custom format I used was #### #### #### ####.
What should I change with this format?