Home › Functions › Text › VALUE
fx
VALUE
Text  ·  Since: Excel 2003  ·  9 languages

Converts a text string that represents a number to a number.

🌐 Translations

English VALUE
Deutsch WERT
Français CNUM
Español VALOR
Italiano VALORE
Português VALOR
Nederlands WAARDE
Polski WARTOŚĆ
Русский ЗНАЧЕН

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

VALUE(text)

Arguments

text (required) — The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.

▶ Examples

=VALUE("$1,000")
=VALUE("16:48:00")

Related functions

Copied to clipboard