View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gerald
 
Posts: n/a
Default date format help

would appreciate if I get help in my query

I have a excel file exported which has 500 rows in which date is in
mm/dd/yyyy format.

Need to have in dd/mm/yyyy format, tried text to columns, custom change date
format, nothing seems to work

plz help

thanks