Thread
:
input mask in excel sheet
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
Posts: n/a
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?
Reply With Quote