Microsoft Excel Hints and Tips
Question
The dates are in US format and in text. How do I convert them into UK
date format, with the correct serial numbers ?
Solution
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.
Return to Excel Exchange homepage.