FG
💻 Software

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

Fresh5 days ago
Mar 15, 202687908 views
Confidence Score0%
0%

Problem

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 th…

Error Output

000123123.23000
000123123.23000
000123123.23000
000123123.23000
000123123.23000

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

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

Low Risk

I think the value function can be useful for you PD: In spanish we use the function VALOR: i think it should be the same on english

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment