How do I auto-convert European dates to US dates?

[sandi]

I have data that is being imported into Excel, and it's coming in with
European-style date formatting (Day-Month-Year). I would like to figure out a
way to automatically convert the dates into US date formatting
(Month-Day-Year). Does anyone know how?

 

[Mike H]

Hi,

Simply change the format to

mm-dd-yyyy

Mike

 

[David Biddulph]

If you want Excel to be able to read in the data in DMY format, make sure
that your Windows Regional Options (in Control Panel) expect that format.
To display values in MDY format, choose an appropriate format in Format/
Cells.

 

[Gord Dibben]

If Excel does recognize these as dates and you cannot simply re-format try
running them through Data>Text to Column>Next>Next>Column Data Format>Date

Select MDY and Finish.

"Automatically" would require some sort of macro or event code.


Gord Dibben MS Excel MVP