Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
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 version
Available
Excel 2007
✓
Excel 2013
✓
Excel 2019
✓
Excel 2021
✓
Microsoft 365
✓
Translate a formula with this function
fx
EN
=VALUE("$1,000")
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
ARRAYTOTEXT
ASC
BAHTTEXT
CHAR
CLEAN
CODE
CONCAT
CONCATENATE
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›