Input Mask in 2003?

[Soaring_Eagle]

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]

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