View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gerald
 
Posts: n/a
Default date in mm/dd/yyyy

I have excel sheet exported from website which already has date field and 50
rows in mm/dd/yyyy format, how to change to dd/mm/yyyy

tried DataText to Columns OPTION but does not work

plz help

thanks