Can I set an input mask for a cell?
 

I have a cell that holds dates. I would like to set a date input mask. So, I
don't have to type out 2/18/2005. I would like to just type 021805. Would
save me lots of time.

Thanx,
Choro

Can I set an input mask for a cell?
 

Choro

Visit Chip Pearson's site for code.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben Excel MVP

On Fri, 18 Feb 2005 18:23:05 -0800, "Choro"
wrote:

I have a cell that holds dates. I would like to set a date input mask. So, I
don't have to type out 2/18/2005. I would like to just type 021805. Would
save me lots of time.

Thanx,
Choro