Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automaticaly put in the / in a date field
I want my users to input a date in the format dd/mm/yy
I know some of them will mis out the separators and enter for example 140301 for the 14th March 2001, but Excel changes the date to something totally different. How can I create a mask (like in Access) so the separators are already displayed in the cell? For example the cell would look like / / and when the date is input it automatically jumps over the separator. |
#2
|
|||
|
|||
You could use a worksheet event that changes the entry to a date. Chip Pearson
has some code at: http://www.cpearson.com/excel/DateTimeEntry.htm Keith wrote: I want my users to input a date in the format dd/mm/yy I know some of them will mis out the separators and enter for example 140301 for the 14th March 2001, but Excel changes the date to something totally different. How can I create a mask (like in Access) so the separators are already displayed in the cell? For example the cell would look like / / and when the date is input it automatically jumps over the separator. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table date field | Excel Worksheet Functions | |||
Convert 20050118 to a working date field | Excel Worksheet Functions | |||
Validating a date field | Excel Discussion (Misc queries) | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
How do I add a date field in a spreadsheet? | Excel Worksheet Functions |