View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do I auto-convert European dates to US dates?

Hi,

Simply change the format to

mm-dd-yyyy

Mike

"sandi" wrote:

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?