Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
input mask in excel sheet
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Confusing Invisible Excel Sheet | Excel Discussion (Misc queries) | |||
Copy Name and email address from web sites to excel sheet | Excel Discussion (Misc queries) | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |