VALUE function
VALUE converts number-like text into a real number so it can be used in math. It often fixes numbers that were imported as text. Text that is not numeric gives #VALUE!.
Example
Read it as a sentence: turn the text 1,234.5 into a number, which gives 1234.5.
A
B
C
D
1
1234.5
2
3
Syntax
VALUE(text)
-
text(required) - Text that looks like a number, date or time.
Returns: The number.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=VALUE("123") | 123 | Text number |
=VALUE("$1,234.50") | 1234.5 | Currency and thousands |
=VALUE("12%") | 0.12 | Percent |
=VALUE("1/9/2026") | 46031 | Date text |
=VALUE("10:30") | 0.4375 | Time text |
=VALUE(" 12 ") | 12 | Surrounding spaces |
=VALUE("abc") | #VALUE! | Bad text |
=VALUE("") | #VALUE! | Empty text |
Watch out for
- Interpretation depends on regional separators.
- Non-numeric text gives #VALUE!.
Where it works
- Excel
- VALUE is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .