Input Mask in 2003?

Soaring_Eagle · May 28, 2008

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

Dave Peterson · May 28, 2008

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