Custom number format always defaults last number to 0.

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

Guest

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,
 

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

Similar Threads

Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Custom Number Format for text 8
Format cell to Number 14
Custom Format 6
Number format 4
Format Number 3
excel changes the last number I type in column??? 5
Entering a 16 digit number 1

Top