Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 27th 09, 10:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 42
Default 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   Report Post  
Old January 27th 09, 10:59 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
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?

  #3   Report Post  
Old January 27th 09, 11:03 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default 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   Report Post  
Old January 27th 09, 11:33 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert dates stored as dates to text? diamunds Excel Discussion (Misc queries) 5 September 7th 07 05:38 PM
How do I convert US style dates to European style? Neo Excel Discussion (Misc queries) 3 October 15th 06 02:24 PM
CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT les8 New Users to Excel 8 August 8th 06 05:48 PM
need to convert list of dates to count no. of dates by week neowok Excel Worksheet Functions 13 January 30th 06 04:54 PM
Any way to force European format dates in sheets? neil f New Users to Excel 6 December 12th 04 10:52 PM


All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017