Excel Date Formatting

Question

I have a large imported csv file containing American Dates in a column. I want to change these dates to UK format (dd/mm/yyyy) using a code. The problem is the US dates are in both "mm/dd/yyyy" and "m/dd/yyyy" format- the latter of which does not respond to any of the "clickable" options in excel- including the "Text to Columns" procedure. Is there a code which when run in the adjacent column will do the conversion?

Answer 1

Take the following steps:
Choose the cells you want to format from the drop-down menu.
CTRL+1 is the shortcut key.
Click the Number tab in the Format Cells box.
Select Date from the Category drop-down menu.
Select a date format from the Type drop-down menu.
Choose the language in Locale if you wish to use a date format that is similar to how dates are displayed in another language (location).