M mik. Sep 3, 2003 #1 ....how do make a column have a date input mask, for example, in XL2000? Thanks.
G Gord Dibben Sep 5, 2003 #3 mik If, by "mask" you mean quick entry of dates as in 21203 entered equals February 12th, 2003, you can't without using code. Chip Pearson has code for this at http://www.cpearson.com/excel/DateTimeEntry.htm Gord Dibben Excel MVP XL2002
mik If, by "mask" you mean quick entry of dates as in 21203 entered equals February 12th, 2003, you can't without using code. Chip Pearson has code for this at http://www.cpearson.com/excel/DateTimeEntry.htm Gord Dibben Excel MVP XL2002