Turn numbers stored as text into real numbers you can calculate with.
Copy this formula
=VALUE(A2)VALUE converts a numeric-looking text string into a number. A quick alternative is multiplying by 1 (=A2*1) or adding 0. This fixes the 'numbers won't sum' problem caused by imported text.
=VALUE("1,250")→1250Text becomes a usable number.
Quick coercion
=A2*1Multiplying by 1 also forces a number.
They're text. Wrap in VALUE, or select the range and use the green error triangle ▸ Convert to Number.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.