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:
- Removing commas using find and replace
- Using the "Trim" function to remove spaces
- 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