Excel: How to convert "string" to a "number"?

"I think the value function can be useful for you

= VALUE(< CELL >)

PD:

In spanish we use the function VALOR:

= VALOR(< CELL >)

i think it should be the same on english"

"I had the same problem, but the VALUE-function did not work in my tsv-file.
But a small trick did the job:

select the column with the numbers in text-format
Ctrl+F --> replace . with ,

(Normally I would hate such solutions, but as said, I just post it here because the 'normal' way of solving it didn't work out for me.)"