View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
juamig
 
Posts: n/a
Default Formula for changing date format

Is there an easy way to change a date format from mm/dd/yy to yyyymmdd?

Also how would I perform the function of only coping over the year to a new
column once I have it in the yyyymmdd format?