VALUE
Supported, behaves as documentedCategory: Text · Last tested 2026-07-04
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel | Yes | Not yet | n/a |
| Google Sheets | Yes | Not yet | n/a |
| LibreOffice Calc | Yes | Yes (24.2.7.2, 2026-07-04) | Supported, behaves as documented |
Executed test cases
LibreOffice Calc 24.2.7.2 (tested 2026-07-04)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =VALUE("123") | Basic numeric-looking text string converts to a number | 123 | 123 | Matched |
| =VALUE("50%") | A percentage-formatted text string converts to its underlying decimal, since Excel stores percentages internally as decimals (50% == 0.5) | 0.5 | 0.5 | Matched |
| =VALUE("$1,000") | Currency formatting (symbol + thousands separator) is stripped during conversion; matches Microsoft's own VALUE documentation example | 1000 | 1000 | Matched |
| =VALUE("abc") | A string that isn't a recognized number/date/time format -> #VALUE! | #VALUE! | #VALUE! | Matched |
Docs & syntax
- Excel: official documentation
- Google Sheets: official documentation
- LibreOffice Calc: official documentation