Xcel convert string to interger
Get via App Store Read this post in our app!
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:
These are really numbers, however they cannot be summed. The correct way to fix this might be to cast the data in the SQL query, but then the Excel query viewer can't display it. As a workaround I do
Is there a more elegant solution?
I think the value function can be useful for you
In spanish we use the function VALOR:
i think it should be the same on english
I use this little macro
Which converts all the highlighted cells to numbers if they're strings
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.)