View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VA VA is offline
external usenet poster
 
Posts: 1
Default Changing date to eliminate day in format mm/dd/yyyy

Assistance with removing day from date format. Wish to change column of
dates which are in format mm/dd/yyyy to new value yyyy-mm. Converted dates
in column are then to be used in a pivot table, to sort data by monthly
occurances. The pivot table presently sorts by daily occurances as the date
is in mm/dd/yyyy format.