Converting US dates to UK dates

[GOBBYGIBBO]

Hello All
1st post on the forum, having looked around I'm sure my issue will be answered. As staed I have a repot that conatins US style dates which I need to convert to UK style, I've tried the various formula's and links I've seen on the forum, all without succes (that may be down to your's truly.........) It seems so simple chnage 04/20/12 to 20/04/12. What little hair I have on the top of my head is quickly dissappearing because of this. HELP!!!!!!!!!

[jake.masters]

Try this solution:

http://forums.techguy.org/business-a...mat-excel.html

Open the spreadsheet attached, and the formulas are there. They do both 2 digit years and 4 digit years.

[GOBBYGIBBO]

Brilliant, you made an ageing person v happy