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

 

[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