Microsoft Excel Hints and Tips
The dates are in US format and in text. How do I convert them into UK date format, with the correct serial numbers ?
If your US format date is in cell A1 - and looks like this "12/20/2005" - then type =DATEVALUE(MID(A1,4,3)&LEFT(A1,3)&RIGHT(A1,4)) - and then change your cell format to a date.
Back to Questions Index
Return to Excel Exchange homepage.