View Single Post
  #2   Report Post  
Old March 22nd 16, 11:22 AM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
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