VALUE

VALUE turns text that looks like a number into an actual number. It is the fix when SUM or math operators ignore values that appear numeric but are stored as text.

Excel

=VALUE(A2)

Google Sheets

=VALUE(A2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1A2 holds a number stored as text (often left-aligned).
2VALUE converts it to a real number.
3Multiplying by 1 (=A2*1) does the same thing.

Need a version for your data?

Try: “Convert the text-number in A2 into a real number”

TEXTJOIN LEFT / RIGHT / MID TRIM

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

VALUE

Try it with your data

How it works

Related