Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 22nd 16, 11:14 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 94
Default CONVERSION OF TEXT TO DATE

How can I convert list of dates which are in text format in a mixed manner into date format "dd-mm-yyyy"

example:

Col A Col B

01.04.2013 01-04-2013
2.5.2013 02-05-2013
11.6.13 11-06-2013
9.7.2013 09-07-2013
01.8.2013 01-08-2013

In "Col A" the list and what I expect is in "Col B"

Please help.

Regards.

-via135


  #2   Report Post  
Old March 22nd 16, 11:22 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,872
Default CONVERSION OF TEXT TO DATE

Hi,

Am Tue, 22 Mar 2016 04:14:03 -0700 (PDT) schrieb via135:

How can I convert list of dates which are in text format in a mixed manner into date format "dd-mm-yyyy"

example:

Col A Col B

01.04.2013 01-04-2013
2.5.2013 02-05-2013
11.6.13 11-06-2013
9.7.2013 09-07-2013
01.8.2013 01-08-2013


try it with Text to columns. In step 3 choose Date "DMY"
and then format the dates as expected.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #3   Report Post  
Old March 22nd 16, 11:42 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 94
Default CONVERSION OF TEXT TO DATE

On Tuesday, 22 March 2016 16:44:09 UTC+5:30, via135 wrote:
How can I convert list of dates which are in text format in a mixed manner into date format "dd-mm-yyyy"

example:

Col A Col B

01.04.2013 01-04-2013
2.5.2013 02-05-2013
11.6.13 11-06-2013
9.7.2013 09-07-2013
01.8.2013 01-08-2013

In "Col A" the list and what I expect is in "Col B"

Please help.

Regards.

-via135


Thanks.!!!!

-via135
  #4   Report Post  
Old March 31st 16, 12:21 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2011
Posts: 31
Default CONVERSION OF TEXT TO DATE



"via135" wrote in message
...

On Tuesday, 22 March 2016 16:44:09 UTC+5:30, via135 wrote:
How can I convert list of dates which are in text format in a mixed manner
into date format "dd-mm-yyyy"

example:

Col A Col B

01.04.2013 01-04-2013
2.5.2013 02-05-2013
11.6.13 11-06-2013
9.7.2013 09-07-2013
01.8.2013 01-08-2013

In "Col A" the list and what I expect is in "Col B"

Please help.

Regards.

-via135


Thanks.!!!!

-via135

Try this: (Works with Excel 2010, should work with all others?)

Highlight the text that you want converted
select Find & replace, choose replace
Find "." and replace with "-"
in the replace with section, choose format
choose number with custom category
Under "type" enter mm-dd-yyyy Ok
then select replace all.




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
Text To Date Conversion John Calder New Users to Excel 2 March 9th 10 10:49 PM
Date to Text conversion Michael Koerner Excel Programming 10 July 30th 09 08:46 PM
Date to text conversion Toke Excel Discussion (Misc queries) 1 August 22nd 08 10:44 AM
Date to text conversion ginnyst Excel Discussion (Misc queries) 4 December 7th 07 03:32 PM
text to date conversion samuel Excel Worksheet Functions 3 August 17th 07 02:23 AM


All times are GMT +1. The time now is 10:40 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017