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.

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