Excel is limited to 15 digit numbers.

Since you aren't likely to be adding CC#s together, there is no reason you
can't store them as text.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"scubadave" <scubadave@discussions.microsoft.com> wrote in message
news:E3434FF8-DF2E-4559-A0C0-5BC1170F40AA@microsoft.com...
>I am trying to format cells to input credit card numbers in Excell 2000.
> When I set up a custom number format for four sets of four numbers
> (####-####-####-####) the result always changes the last number to a 0.
> How
> do I overcome that?