Changing text to number format

[goingvirtual]

I copied data from a table into Excel, and when I tried to multiply two numbers together, it results in "#VALUE!". I thought that probably means that the numbers are formatted as text, so I've tried:

1. Removing commas using find and replace
2. Using the "Trim" function to remove spaces
3. Using the "Value" function to change from text to numerical formatting

However, I'm still getting the same #VALUE! result when I try to perform mathematical operations using this data. Any suggestions?



Thanks,
Mike