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