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