How to stop Excel Treating US dates as UK dates?
Posted
by
deworde
on Super User
See other posts from Super User
or by deworde
Published on 2012-04-04T09:35:37Z
Indexed on
2012/04/04
11:33 UTC
Read the original article
Hit count: 189
I'm in the UK, I've got a problem where I've got a list of dates supplied in US format. Excel seems to treat the ones that are valid in both formats as UK dates, (e.g. 03/01/2012 becomes 3rd of January rather that 1st March), and treat the ones that aren't valid UK dates (e.g. 03/13/2012) as basic text. I assume this choice is something to do with my regional settings.
What I want is the system to recognise that this column of text is supplied in US date format, and convert it into the underlying date representation for calculations.
How do I do this?
© Super User or respective owner