Cells only accept 15 numbers.

[Michael]

Can anyone tell me how to make Excel accept more than 15
numbers in a cell. Every time I enter my Credit Card # in
a cell, it always turns the last numeral to zero,
regardless of what I enter as the last numeral.

I tried creating a custom format of 0000-0000-0000-0000
for the cell but it still turns the last numeral to zero.

Cheers
Michael

 

[Peo Sjoblom]

Precede the entry with an apostrophe or per-format cell as text

 

[Gord Dibben]

Michael

Pre-format the cell to Text or precede the number with an apostrophe.

This will make your CC number text but you don't use it in calculations, so it
doesn't matter.

Gord Dibben Excel MVP

 

[Michael]

Thanks guys. Why didn't I think of that. I appreciate your
responses.

Cheers
Michael