| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| Date format yyyy/mm/dd | Excel Discussion (Misc queries) | |||
| Date format from yyyy-mm-dd-hh | Excel Discussion (Misc queries) | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
Threaded Mode
