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!
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...
You're completely missing the point of this car I think mate. I can see how some people hate 5 doors and that's fair enough. Some people like fat birds as well, but this was never intended to be a 172 cup. Of course that car would look retarded with 5 doors, this one doesn't though IMO. Looks...