Convert text to number in excel 2010?

Please help, I imported data to excel and the cells that I want to sum are recognized as text. I did the following, all of which did not work: 1. I formatted these cells to General which did nothing, then formatted to Number which also didn't make a difference. 2. I entered the number 1 in another cell,... show more Please help, I imported data to excel and the cells that I want to sum are recognized as text. I did the following, all of which did not work:
1. I formatted these cells to General which did nothing, then formatted to Number which also didn't make a difference.

2. I entered the number 1 in another cell, then copied and pasted as special... Add in the text cells.

3. I converted text to number with the value function.

I trust that you will provide me with a solution that will put a :) on my face.

Thanks
Update: I tried "Multiply" - this also does not work
4 answers 4