Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
Brian is selling his LY. I think he's buying a Noble M400.
Personally, Clio 200 feels much more composed than any 182 I've driven and inspires much more confidence.
I'd use text functions to arrange it as a UK date, C&P special values then format it as a date.
i.e to get 09/03/2012 into UK date it would be =mid(a1,4,2)&"/"&left(a1,2)&"/"&right(a1,4)
or you could do it all in one function...
=date(right(a1,4),left(a1,2),mid(a1,4,2))
It's difficult togive...