Skip to content

VALUE

TextExcel 2007

Convert a text string that looks like a number into a real number.

Syntax

VALUE(text)

Examples

=VALUE("₹1,250")

→ 1250 — In many locales; otherwise strip symbols first.

Related functions

TEXTNUMBERVALUE

More Text functions

ARRAYTOTEXTASCBAHTTEXTCHARCLEANCODECONCATCONCATENATEDBCSDOLLAREXACTFIND

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.