C
CSBUG
I'm creating a form where you can enter a credit card number. I set a
custom number for the cell and described it as ####-####-####-####. You
can enter a 16 digit number just fine, but when you tab away from the
cell and the custom number takes place, it changes the last digit to a
"0". Has anyone else encountered this? How do I fix it? I was told I
could add an apostrophe before the entry, but this form is going to be
used by hundreds of employees, so it needs to work automatically.
Suggestions?
custom number for the cell and described it as ####-####-####-####. You
can enter a 16 digit number just fine, but when you tab away from the
cell and the custom number takes place, it changes the last digit to a
"0". Has anyone else encountered this? How do I fix it? I was told I
could add an apostrophe before the entry, but this form is going to be
used by hundreds of employees, so it needs to work automatically.
Suggestions?