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.