input mask in excel sheet

[Guest]

I need to specify a cell for input mask as in access. I mean when I write a
date the cell field show me __/__/_____ same as acess when I wirte a date
comes likes this 04/__/_____ until I complete the date 04/12/2005. Is it
possible in excel?

 

[Gord Dibben]

Possible, yes.

But not without employing VBA code. Excel does not provide for input masks as
does Access.

See Chip Pearson's site on Quick Entry of dates and times.

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


Gord Dibben Excel MVP

On Sat, 3 Dec 2005 23:46:01 -0800, "Osama Mira" <Osama