Hi
i have imported a CSV file into excel
this file has a column containing dates
this column is formatted mm/dd/yyyy hh:mm:ss

how can i change this format to dd/mm/yyyy


i have tried copying and formatting the column to dd/mm/yyyy but still
leaves the hh:mm:ss

any ideas

thanks

kev