Credit Card #

K

kmcguire

When I place a CC# into my excel worksheet it is changing the last number
(16) to a zero. How can this be stopped
 
D

Dave Peterson

format the cell(s) as text first

or

precede your credit card number with an apostrophe:

'1234123412341234

(Excel only keeps track of up to 15 digits in real numbers.)
 
P

Paul

Formatting cells as text in advance is good, but I prefer to precede the
number with a "cc". This makes it clearly visible that the last digit has not
been changed to 0. If I need to, I can revert to a pure number via the
formula =right(A1, (len(A1)-2)).

Regards
Paul
 

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

Making id cards 1
Sorting and filtering text 0
Typing a credit card number in a cell 3
Embed the same Excel multiple times 0
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Enter credit card number in a cell 2
Formatting Credit Card #'s with Dashes 4
rounding problem need accuracy when using V Lookup 2

Top