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" wrote in message
...
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?
|