Anyone know how to set an input mask for cells in excel. I would like
to have the date displayed when I type without having to type the / or
-.
TIA
You can use an event macro that looks at your entry and converts it to a date.
Chip Pearson has the code here:
http://cpearson.com/excel/DateTimeEntry.htm
> Anyone know how to set an input mask for cells in excel. I would like
> to have the date displayed when I type without having to type the / or
> -.
>
> TIA

Signature
Dave Peterson