Home » Questions » Computers [ Ask a new question ]

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

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

I have a user with a query from an SQL Database that returns a series of string in this form:

Asked by: Guest | Views: 24
Total answers/comments: 2
Guest [Entry]

"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"
Guest [Entry]

"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.)"