| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change custom format number to text | Excel Discussion (Misc queries) | |||
| Want a number of cells to be auto completed based on entry in one. | Excel Worksheet Functions | |||
| How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
| Create an Auto Number | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
