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

I have 250 rows with date in mm/dd/yyyy, how can I change it to dd/mm/yyyy
format.

Tried from FormatCustommm/dd/yyyy, though even after selecting this
option date does not change for the rows

please advise

thanks