I have several workbooks that I distribute where I have formatted the date
columns to display as dd-mmm-yyyy. The users fill in these dates. This is
the way I want them formatted, because that is the way they ultimately need
to be entered into our computer system.

The problem is, if the user looks at the instructions to enter as
dd-mmm-yyyy and mearly thinks, "Ok -- day, monty, year" and enters the 7th of
January, 2005 as 7-1-2005, it will display as 01-Jul-2005 and not
07-Jan-2005. This is because of the regional settings, I realize. I can't
ask people to change their regional settings, so how can I ensure that if
they enter the date as day-monty-year (numerically) it will actually display
as such? Is this impossible? Is there a macro in existance? I need more
control!

Help!