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

  • Thread starter Thread starter sandi
  • Start date Start date
S

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?
 
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
 
Back
Top