Excel is treating your pasted value(s) as text. You can quickly convert a
range of cells to text by copying an empty cell, selecting the offending
values, and using Edit-Paste Special-Values-Add

Alternatively, in the formula(s) that reference the offending cells, wrap
the reference in the VALUE() function

"Miffed" wrote:

When I copy text from an emailed Word file, paste it into Excel 2003
worksheet, my formulas in the worksheet won't work. If I manually type in
the text in the cell in the worksheet, the formula will work. Any
suggestions on how to get the formulas to recognize the Word text in the
formula? Thank you in advance.
--
Help Wanted