input masks

mik. · Sep 3, 2003

....how do make a column have a date input mask, for
example, in XL2000?

Thanks.

Ron de Bruin · Sep 3, 2003

See the thread "Calendar" from today
Maybe you like that one

Gord Dibben · Sep 5, 2003

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

Input mask for date!	0	Sep 28, 2011
Date input format	2	May 20, 2010
date input mask	1	Oct 29, 2008
How do I create a date format	2	Apr 17, 2008
Formatting cells to only upper case	5	Feb 28, 2010
date mask	1	Aug 17, 2005
Is there a way to have fixed format in a userform?	9	Feb 19, 2008
Input masks in Excel	1	Oct 16, 2006

input masks

mik.

Ron de Bruin

Gord Dibben

Ask a Question

Similar Threads