How to stop Excel Treating US dates as UK dates?
- by deworde
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?