Convert text to "mm/dd/yyyy hh:mm:ss" format

Is it possible to get a macro to convert the values on column D and E to "mm/dd/yyyy hh:mm:ss" format.

Attached the workbook. Currently the values are shown as text and I was not able to change them any other way. Text to Columns will not work for me as it requires inserting new columns

I tried at Excel General but didn't really find a solution that I can use for what I wahttp://www.excelforum.com/excel-gene...ates-time.html

I think a code will be the best way to do it. Will appreciate any help.

Doesn't work by using text to columns. I follow these steps and value remains as "text". This is the way this report is generated and I cannot change it unfortunately

It is strange because it working for some people and for some other computers. Maybe the problem is with my excel settings after I re-installed windows and office and the way excel reads dates

I found the problem. It was my regional windows settings. Had to change the settings to English (United States). After that excel would read the dates as normal. Thanks