|
Auto Formatting Custom Number
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? -- CSBUG ------------------------------------------------------------------------ CSBUG's Profile: http://www.excelforum.com/member.php...o&userid=28846 View this thread: http://www.excelforum.com/showthread...hreadid=485951 |
Auto Formatting Custom Number
Precede you entry with a single apostrophe.
_____________________________________ Gary's Student "CSBUG" wrote: 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? -- CSBUG ------------------------------------------------------------------------ CSBUG's Profile: http://www.excelforum.com/member.php...o&userid=28846 View this thread: http://www.excelforum.com/showthread...hreadid=485951 |
Auto Formatting Custom Number
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? Gary''s Student Wrote: Precede you entry with a single apostrophe. _____________________________________ Gary's Student "CSBUG" wrote: 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? -- CSBUG ------------------------------------------------------------------------ CSBUG's Profile: http://www.excelforum.com/member.php...o&userid=28846 View this thread: http://www.excelforum.com/showthread...hreadid=485951 -- CSBUG ------------------------------------------------------------------------ CSBUG's Profile: http://www.excelforum.com/member.php...o&userid=28846 View this thread: http://www.excelforum.com/showthread...hreadid=485951 |
Auto Formatting Custom Number
You have a response in .excel, too.
CSBUG wrote: 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? -- CSBUG ------------------------------------------------------------------------ CSBUG's Profile: http://www.excelforum.com/member.php...o&userid=28846 View this thread: http://www.excelforum.com/showthread...hreadid=485951 -- Dave Peterson |
Auto Formatting Custom Number
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. "CSBUG" wrote: 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? Gary''s Student Wrote: Precede you entry with a single apostrophe. _____________________________________ Gary's Student "CSBUG" wrote: 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? -- CSBUG ------------------------------------------------------------------------ CSBUG's Profile: http://www.excelforum.com/member.php...o&userid=28846 View this thread: http://www.excelforum.com/showthread...hreadid=485951 -- CSBUG ------------------------------------------------------------------------ CSBUG's Profile: http://www.excelforum.com/member.php...o&userid=28846 View this thread: http://www.excelforum.com/showthread...hreadid=485951 |
| All times are GMT +1. The time now is 06:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com