| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Format for credit card numbers
I've tried a custom format for entering credit card numbers (four groups of four digits, separated by dashes: xxxx-xxxx-xxxx-xxxx. I have tried to use ####-####-####-#### and 0000-0000-0000-0000 but each of these causes the last digit to change to zero. So if I enter 5415779800902512 I get 5415-7798-0090-2510. Anybody already solved this problem? -- Schmacker ------------------------------------------------------------------------ Schmacker's Profile: http://www.excelforum.com/member.php...o&userid=28041 View this thread: http://www.excelforum.com/showthread...hreadid=475488 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parse text & numbers & format | Excel Worksheet Functions | |||
| How to format numbers that are already entered? | Excel Worksheet Functions | |||
| How do I format charge card numbers? | Excel Discussion (Misc queries) | |||
| Format numbers in chart datatable | Charts and Charting in Excel | |||
| Converting numbers to date format from csv files | Excel Discussion (Misc queries) | |||
Threaded Mode
