In Excel, is there a way to enter dates in mm/yyyy format?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I need is for the cell to remember the date as mm/yyyy. when I format
the cell to display this, it still puts the day in there even though it is
not displayed. I need to be able to enter 05/06 and know that is a month and
a day. I need also for Excel not to automatically assume that it is
05/06/2006. Any suggestions?
 
There are no dates without days thus you need to use text (precede the entry
with an apostrophe or format as text) Excel will always insert the current
year whenever you enter something Excel interprets as a date without a year.
So you need to enter a text representation of it


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
If you do not want to go the text route you can add a column to the right of
your dates column and add the following formula =Month(A1)&"/"&Year(A1).

Where A1 is the first cell containing a date value.
 
Back
Top