Excel has only 15 digits precision and you can't use a custom text format
that way,
You need to either preformat as text or precede the entry with an apostrophe


Regards,

Peo Sjoblom

"becky" wrote:

I have created a custom format for a cell that will be used in a general
company form. The custom format is for a credit card number and was written
as follows: #### #### #### ####. When ever I type in a number 9999 9999
9999 9999 the final digit is convert to a zero. I do not understand why it
is doing this. It is not being rounded. Can anyone help correct this very
irritating formatting issue?

Thanks
--
bb