Convert text to number in excel 2010?
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.