Auto Formatting Custom Number

[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?

 

[Gary''s Student]

Precede you entry with a single apostrophe.
_____________________________________
Gary's Student

 

[CSBUG]

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?

 

[Dave Peterson]

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?

 

[Suresh]

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.