Spreadsheet formulas explained, side by side

VALUE Function in Excel, Google Sheets, Airtable & Notion

VALUE converts text that looks like a number into an actual number you can calculate with. VALUE("$1,234.50") is 1234.5.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inVALUE(text)
For other number formats use NUMBERVALUE(text, decimal_separator, group_separator), e.g. for “1.234,50”.
Google Sheets✔ Built inVALUE(text)
Airtable✔ Built inVALUE(string)
Strips currency symbols and thousands separators. Percent signs and some minus signs may not convert the way Excel does, so the tester removes % and divides by 100 itself.
Notion✔ Built intoNumber(text)
Expects a plain number. Strip symbols first: toNumber(replaceAll(prop("Price"), "[^0-9.-]", "")). Returns empty when the text is not a number, instead of an error.
Try VALUE with your own values
Try 12%, (250), 1.5E3, 12:30 or 2026-01-31
Result (as Excel & Google Sheets return it)
1,234.5
Your formula, ready to paste
Excel=VALUE("$1,234.50") open excel.new ↗
Google Sheets=VALUE("$1,234.50") open sheets.new ↗
AirtableVALUE("$1,234.50")
NotiontoNumber(replaceAll("$1,234.50", "[^0-9.-]", ""))

The tester follows Excel in the US locale: $ and commas are allowed, (250) is −250, and dates in YYYY-MM-DD form become serial numbers. The Airtable and Notion versions handle plain numbers, currency and percentages, but not dates or times.

Arguments

ArgumentWhat it means
textText containing a number, currency amount, percentage, date or time.

Examples

FormulaResultWhyCopy
=VALUE("$1,234.50")1234.5Currency symbol and commas are accepted.
=VALUE("12%")0.12Percentages become fractions.
=VALUE("12:30")0.5208333Times become fractions of a day.
=VALUE("abc")#VALUE!Not a number.

Examples use Excel / Google Sheets syntax unless noted.

How VALUE works

Numbers stored as text are a common reason a spreadsheet adds up wrong: they come from CSV imports, copied web tables and functions like LEFT, MID and SPLIT, which always return text. SUM silently skips them and lookups fail to match the number 42 against the text “42”. VALUE converts them. =A2*1 and =--A2 do the same in a shorter form.

VALUE follows your spreadsheet locale. In a US locale “1,234.50” works but “1.234,50” returns #VALUE!; use NUMBERVALUE(A2, ",", ".") in Excel to say which separators the text uses. Dates and times written as text are converted to their serial numbers, so format the result as a date to see it as one.

Airtable's VALUE is more forgiving with currency symbols and separators, but check percentages and negative amounts in your own data. Notion's toNumber() expects a clean number, so strip everything except digits, the decimal point and the minus sign with replaceAll() first.

Frequently Asked Questions

How do I convert a whole column of text numbers?
Either use =VALUE(A2) in a helper column and paste the results back as values, or select the cells and use Excel's “Convert to Number” warning menu or Data → Text to Columns → Finish.
Why does VALUE return #VALUE! for a number with spaces?
Spaces between digits (for example “1 234”) and non-breaking spaces aren't allowed. Remove them first: =VALUE(SUBSTITUTE(SUBSTITUTE(A2, " ", ""), CHAR(160), "")).

Part of the Text functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.