Hi Charles,
No, my query was regarding copying a table from MS Word and pasting in MS Excel, where it automatically formats cells and gives me wrong results. I had cells containing for instance 4:12 (text) and it auto formats to 04:12 AM (time format). But I managed to resolve it by copying to Notepad++ first and then to Excel, so this thread can be closed.