Import Table From Word 2003 to Excel 2003
I have a Word 2003 table which contains 2 columns and 300 rows of data, the first column is a date (from Monday to Friday, excluding public holidays)and the second column is a number (say the market price of a certain stock).
I need to import these 2 columns of data into an Excel 2003 worksheet, same column & row structure.
How can I do it without re-keying ?
Appreciate your help.
Dates Column in Word 2003 to Cells in Excel 2003
No - Excel does not change the date format.
I tried formatting the cells first, then paste.
I also tried formatting the cell after I paste, too.
There is no change in the date format.