Yes, XL, like most spreadsheets, has a 15-decimal digit precision.

But since you're almost certainly not doing math on the credit card
number, either preformat the cell as Text (so XL won't interpret the
entry as a number), or prefix the entry with an apostrophe:

'0123456789012345



In article ,
Jimbo wrote:

Every time I try to put in the last number of my 16 digit credit card number
Excel makes it a zero. I have tried formatting in number and text.