I have an excel file which hold a huge data. some of its rows of the date column in Us format and other in UK. How can make them all in UK format?
The format as following
mm/dd/yyyy hh:mm:ss and other like that dd-mm-yyyy hh:mm:ss
I need it to be dd/mm/yyyy hh:mm:ss