Credit Card Mask Not Working

B

Barb

I don't know if anyone else has had this problem or if
there is a solution. I'm using Excel 2000 and applying a
mask to a field that will have a credit card entered. I
tried the following two masks and for some reason the last
digit always is a 0. Is there a limit to the field length
you can use in a mask?

0000-0000-0000-0000
and
####-####-####-####

But I also have a mask for AMEX which is 2 places smaller
than MC or VISA (0000-000000-00000) and it works just
fine. I added enough to that mask to equal the number of
characters in the MC and VISA mask and it also changes the
last number to 0. Makes me wonder if there is a
limitation that I can't find in any documentation.

Any help would be greatly appreciated.
 
N

Norman Harker

Hi Barb!

You'll have to enter as text as Excel only works to 15 significant
figures.

Alternatively you can enter in two cells

12345678
12345678

Then aggregate using:

=TEXT(A1,"####-####-")&TEXT(B1,"####-####")
 
R

Ron Rosenfeld

I don't know if anyone else has had this problem or if
there is a solution. I'm using Excel 2000 and applying a
mask to a field that will have a credit card entered. I
tried the following two masks and for some reason the last
digit always is a 0. Is there a limit to the field length
you can use in a mask?

0000-0000-0000-0000
and
####-####-####-####

But I also have a mask for AMEX which is 2 places smaller
than MC or VISA (0000-000000-00000) and it works just
fine. I added enough to that mask to equal the number of
characters in the MC and VISA mask and it also changes the
last number to 0. Makes me wonder if there is a
limitation that I can't find in any documentation.

Any help would be greatly appreciated.
Click to expand...

Any numeric entry that is more than 15 digits has to be entered as TEXT. Excel
(see specifications) is limited to fifteen decimal precision.


--ron
 
Top