Convert Date to MMYY format

[Doug Muegge]

I would like to change the underlying date format from e.g. 01-May-09 to
May-09. I can change the format so that the displayed date is in correct
format but the underlying date is still in DD/MM/YYYY format. The purpose is
to do pivot charts to show how many defects per month over the last five
years.

 

[Gary''s Student]

Rather than reformat the cell to Custom > mmm-yy

use something like:

=TEXT(A1,"mmm-yy")

 

[Doug Muegge]

This solution worked perfectly - Thank you - saved me considerable time!!!