Custom number format always defaults last number to 0.

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?

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?

Excel only lets 15 digits be used in numbers To have the 16th number most
people use text.

"scubadave" wrote:

> 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?