I had the same problem I wanted dates from format mm/dd/yy (or even mm/dd/yyyy) to be converted to dd/mm/yy. I eventually used this little gem I wrote. (Assume Cell D23 in the example has a date of the above format and you are setup to date format dd/mm/yyyy as default on windows..)...
