| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting for credit card number input
I have a cell in which the user will input a credit card number and I want it
to display a format based on the type of card. So Visa / MC should be "#### - #### - #### - ####" but Amex should be "####-######-#####" - the user will choose the type of card in another cell so what's the most effective way to conditionally format the input to display properly based on the card type? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Credit Card #'s with Dashes | Excel Discussion (Misc queries) | |||
| Credit Card Number in excel | Excel Discussion (Misc queries) | |||
| Credit Card Number | Excel Worksheet Functions | |||
| Credit Card Number | Excel Worksheet Functions | |||
| credit card formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
