I have a lot of cells stored as Text (Copy / Paste from WEB) and I want to Convert them to Numbers.
Text cells like : 10, 15, +34, -340, ....
If I select them all, Format from General to Numbers, when I try to see Value(A1) I get #VALUE!
In A1 is +34 or -340
How to fix this ?
Bookmarks