Credit Card #

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

Guest

When I place a CC# into my excel worksheet it is changing the last number
(16) to a zero. How can this be stopped
 
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.)
 
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
 
Back
Top