Cells only accept 15 numbers.

M

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
 
G

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
 
M

Michael

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

Cheers
Michael
 
Top