| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force users to enter a range of cell in dd/mm/yy hh:mm format
I have created a template which is filled by users for date & time. Since
users are novice, can I force users to enter the cell values only in dd/mm/yy hh:mm format? For ex if a user wants to enter 10th May 09 10:00Am & by mistake he types 10/5/09 10.00 ( uses . instead of colon) excel misunderstands. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i force users to first enter data in one cell before anythi | Excel Discussion (Misc queries) | |||
| Force user to enter data in cell before moving to next cell | New Users to Excel | |||
| Making sure users enter phone numbers in a particular format | Excel Programming | |||
| How to force <enter to behave like <alt + <enter within a cell | Excel Programming | |||
| Not allowing users to enter data into certain cells if another cell is empty | Excel Programming | |||
Threaded Mode
