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?