ExcelBanter - CONVERSION OF TEXT TO DATE

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - CONVERSION OF TEXT TO DATE (https://www.excelbanter.com/excel-worksheet-functions/451354-conversion-text-date.html)

via135

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

Claus Busch

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

via135

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

wabbleknee

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.

All times are GMT +1. The time now is 05:31 PM.