View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Doug Muegge Doug Muegge is offline
external usenet poster
 
Posts: 4
Default Convert Date to MMYY format

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


"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