Entering a 16 digit number

G

Guest

I am creating an Excel worksheet and am trying to enter credit card numbers
in one of the columns. When I enter the number, it automatically changes the
last digit to a "0". How do I format the cells to accept a 16 digit number?
 
P

Peo Sjoblom

Format as text or precede the entry with an apostrophe, excel has 15 digits
precision but I assume you won't do any calculations with credit card number

--
Regards,

Peo Sjoblom

(No private emails please)
 

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
16 digit number entry changes last digit to 0 1
Custom Format on 16 Digit Number 5
16 digit numbers 2
last digit in string gets changed to 0 (16 characters long) 3
Typing a credit card number in a cell 3
How to restrict zeros in a number from 16th digit onwards 5
Excel Changes My Last Digit to Zero 1

Top