Custom number format always defaults last number to 0.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top