View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Convert Date to MMYY format

Rather than reformat the cell to Custom mmm-yy

use something like:

=TEXT(A1,"mmm-yy")

--
Gary''s Student - gsnu200909


"Doug Muegge" wrote:

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.
--
Doug M