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.
|