| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto-convert European dates to US dates?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I auto-convert European dates to US dates?
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. -- David Biddulph "sandi" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I auto-convert European dates to US dates?
If Excel does recognize these as dates and you cannot simply re-format try
running them through DataText to ColumnNextNextColumn Data FormatDate Select MDY and Finish. "Automatically" would require some sort of macro or event code. Gord Dibben MS Excel MVP On Tue, 27 Jan 2009 13:51:01 -0800, 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert dates stored as dates to text? | Excel Discussion (Misc queries) | |||
| How do I convert US style dates to European style? | Excel Discussion (Misc queries) | |||
| CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT | New Users to Excel | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Any way to force European format dates in sheets? | New Users to Excel | |||
Hybrid Mode
