Credit Card #
 

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

kmcguire wrote:

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

--

Dave Peterson

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

"kmcguire" wrote:

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