I have copied a report into Excel 2007 using HTML. After pasting the copy, the report appears nicely in columns.

Three of the columns contain numbers as text.

I need to be able to use these numbers in calculations. So I need to convert the text to numbers. I have tried the copy multiply method without any success.

No matter what I try, when I use the resulting number in a formula I get !VALUE.

Here is one of the numbers $3,538.00.

Any ideas on how to get these text cells into numbers so they can be used in calculations?

## Bookmarks