m/yy or m/yyyy date format
Bigfoot17,
If you enter 3/11 in cell A1 it will return 11-Mar. From there, go to
Format | Cells (or hit Control+1). Now you can modify how the date looks.
It will still retain the day, month and year, but will only show what you
want it to.
In the "Number" Tab, select either Date or Custom in the Category window.
Scroll in the type window for how you want it to appear.
For Mar-08, select mmm-yy.
for March 2008, type in Mmmm yyyy
Hope that helps.
"Bigfoot17" wrote:
I should add that I will be oding some searches and formula calculations on
the month/year.
"Bigfoot17" wrote:
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.
|