Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Mask - Credit Cards
Hi, Thanks in Advance.
I need to create 2 input masks in excel. One for the 16 digit card no which must be numbers from 0-9 in each field. 2nd For the date first two digits 01 to 12 and last 4 2007 onwards. Thanks for your help Trev B |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Mask - Credit Cards
There's nothing built into excel that allows for masks.
In fact, if you want to enter 16 digits in a cell, that cell has to be treated as text (either preformatted as Text or entered with a leading apostrophe). As for dates, you can use Format|Cells|Number tab and choose a nice format for your dates--but this won't affect the way the user types the dates. Trever B wrote: Hi, Thanks in Advance. I need to create 2 input masks in excel. One for the 16 digit card no which must be numbers from 0-9 in each field. 2nd For the date first two digits 01 to 12 and last 4 2007 onwards. Thanks for your help Trev B -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Credit Cards, time in months to payoff and payoff amount | Excel Worksheet Functions | |||
Creating a specialized worksheet for my credit cards. | Excel Discussion (Misc queries) | |||
Input Mask | New Users to Excel | |||
Input Mask | Excel Programming | |||
Mask input in input boxes? | Excel Programming |