Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EAL EAL is offline
external usenet poster
 
Posts: 1
Default Convert european foreign date format to US date format

I receive dates in the following format in column:

dd.mm.yyyy

I would like to convert the column to read mm/dd/yyy.

Any thoughts?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Convert european foreign date format to US date format

If they're really dates with that custom format, you could just change the
format of those cells.

But if the values in the cells are text, you can select the column
Data|Text to columns
Fixed width
Remove any line that excel guessed and don't add any of your won
choose Date (dmy order)
And finish up the wizard.

Then format that column to show the date the way you like.

EAL wrote:

I receive dates in the following format in column:

dd.mm.yyyy

I would like to convert the column to read mm/dd/yyy.

Any thoughts?


--

Dave Peterson
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
convert serial date format to normal date format Flagworld Excel Discussion (Misc queries) 3 September 23rd 08 01:32 PM
Convert European Date format to American Format Albert Excel Discussion (Misc queries) 3 August 21st 07 10:02 PM
how can i change european date format to american pclifford99 Excel Discussion (Misc queries) 11 November 28th 06 03:05 AM
CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT les8 New Users to Excel 8 August 8th 06 05:48 PM
CONVERT 11/23/04 US DATE FORMAT TO EUROPEAN 23/11/04 FATE Roland Excel Discussion (Misc queries) 2 December 20th 04 11:19 PM


All times are GMT +1. The time now is 11:15 AM.

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

About Us

"It's about Microsoft Excel"