Text to Columns issue with Date & Time

C

C Andrews

Apparently the answer was simpler than I thought. The suggestion o
copying the column and then formating the orignal and the new colum
for date and time respectively worked fine.

I also tried the 'text to columns' solution with 'other' checked an
the <Alt> 0160 but that did not work for me. I probably did somethin
wrong.

I have a workable solution, so thank you all for your input
 
Top