View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bigfoot17 Bigfoot17 is offline
external usenet poster
 
Posts: 67
Default m/yy or m/yyyy date format

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.