Input Mask - Credit Cards

[Guest]

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]

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.