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