Train them to use 4 digits for the year!
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bigfoot17" wrote in message
...
I am having problems with some date ofrmat, date entry.
I have a column in which I want to enter stricktly the month and year (NO
day of the month).

If I enter 3/11 to me it means March 2011, but to Excel it is March 11, 2008
(or Mar-08, depending on the format). Any suggestions. I have others that
will be doing the data entry, and I do not want to train them to 'fudge' to
get the format correct.