Custom number format always defaults last number to 0.

S

scubadave

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

bj

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

George Nicholson

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,
 
Top