Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |