When copying a table from Word (2000) into Excel (XP) it converts the numbers
to text so that formulas do not work. The Formula is fine, but the numbers
are seen as text. If I click on one of the number cells, then on the formula
bar, and at the beginning of the content hit backspace, it turns to a number
again, but there is NO SPACE there, must be some other hidden code or
something. I used to get a button that asked if I wanted to insert as text
or numbers, but a tech turned that function off and now it just pastes as
text. How can I get it to ask me again if I want to paste (from Word 2000)
numbers or text? Or better yet, just always paste numbers as numbers by
default?

Any solutions? Please help. Thank you!