View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default input mask in excel sheet

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
wrote:

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?