Custom Date Format Excel 2002

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

Does Ecel 2002 suupirt custom date formats?

I need to format a range of celss with the date format
where date are displayed in this format "mmm-dd"

where I enter "3/4" and "Mar- 4" or " "Mar-04" is displayed

or

I enter "4/15" and "Apr-15" is displayed in the cell.

Can this be done in Excel?

Thanks, Ed
 
Yes, that would work..

Select the input range and use a custom format

mmm-dd

then enter the dates like you want
 
Back
Top