When I format it as text it gives me, 5.4575E+15
I can put a ['] in fron of the numbers and it will work. but is there a way
for me to just type in the numbers and have it format like this:
4525-4545-4585-5656

"Toppers" wrote:

Excel only handles 15 digits so for Credit Cards (and long telephone
numbers!) you should format your cells as TEXT.

"Shivaraj" wrote:

Hello,

I am trying to keep trackof credit card numbers, i put in a custom formating
that looks like this: ####-####-####-#### so i can just type the numbers in
without having to type '-'.

The only problem is that is always turns the last number into a '0' zero.

for instance if the number is:
4519-3589-2000-1875

the formula changes the number to this:
4519-3589-2000-1870

Thank you,

shivaraj