Auto Formatting Custom Number

  • Thread starter Thread starter CSBUG
  • Start date Start date
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?
 
Precede you entry with a single apostrophe.
_____________________________________
Gary's Student
 
If this form is for other people to use. I want them to just type in
the 16 digits and have it format itself. Without having to explain to
150 people that they need to start every entry with an apostrophe.
Should I put the apostrophe in the custom number script?
 
You have a response in .excel, too.
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?
Click to expand...
 
Excel's number precision is maximum 15 digits. So you wont be able to retain
the 16 digit. It is not unique to your format and is a general limitation. I
suggest you define 4 cells in your form to input the card number.
Alternatively, you can use a text box.
 
Back
Top