Import Table From Word 2003 to Excel 2003

[OneBigNewbie]

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.

[Steve R Jones]

Hightlight the info in the tables - COPY

Paste it into Excel..

[OneBigNewbie]

Thanks, Steve,

You are really quick !

Forgot to mention (that is where the problem is) that in the date column, the date format in Word 2003 is in text format, like 'Sat 19-Jul-08'. I do not need 'Sat' [just a simple Excel Date format, such as 19-Jul-08 will be good enough].

Appreciate your help.

[Steve R Jones]

Does Excel not allow you to change the format once you paste?

[OneBigNewbie]

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.

[Tuttle]

Excel won't recognise that as a date -- the leading day confuses it. If it's always of that form, creating a new working column like this should get you a real date (although it'll look like a number):

=DATEVALUE(RIGHT(A1, LEN(A1) - 4))

Then use Copy | Paste Special from that column over the original one, pasting values only. Finally, delete the working column and format the original column as a date.