TEXT
Supported, behaves as documentedCategory: Text · Last tested 2026-08-06
Real, executed compatibility results for the TEXT function across Microsoft Excel, Google Sheets, and LibreOffice Calc — verified by actually running it. Syntax and links to each vendor’s official documentation are below.
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel | Yes | Not yet | n/a |
| Google Sheets | Yes | Not yet | n/a |
| LibreOffice Calc | Yes | Yes (25.8.7.3, 2026-08-06) | Supported, behaves as documented |
LibreOffice version history
We executed the same test cases under each LibreOffice release to show exactly when TEXT’s support changed — not documentation claims, real results.
| LibreOffice version | Verdict | Tested |
|---|---|---|
| 24.2.0.3 | Supported, behaves as documented | 2026-07-19 |
| 24.8.7.2 | Supported, behaves as documented | 2026-07-19 |
| 25.2.0.3 | Supported, behaves as documented | 2026-07-24 |
| 25.8.7.3 | Supported, behaves as documented | 2026-08-06 |
Executed test cases
LibreOffice Calc 25.8.7.3 (tested 2026-08-06)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =TEXT(1234.567,"$#,##0.00") | Currency-style format code with thousands separator and 2 decimal places, rounding the value. Source: https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c (worked example) | $1,234.57 | $1,234.57 | Matched |
| =TEXT(0.285,"0.0%") | Percentage format code multiplies by 100, appends %, and rounds to 1 decimal place. Source: Microsoft TEXT docs worked example. | 28.5% | 28.5% | Matched |
| =TEXT(12200000,"0.00E+00") | Scientific-notation format code. Source: Microsoft TEXT docs worked example. | 1.22E+07 | 1.22E+07 | Matched |
| =TEXT(1234,"0000000") | Zero-padding format code pads with leading zeros to fill every '0' placeholder. Source: Microsoft TEXT docs worked example. | 0001234 | 0001234 | Matched |
| =TEXT(DATE(2024,3,5),"yyyy-mm-dd") | ISO-style date format code applied to a fixed, deterministic date (not TODAY()) so the result is reproducible. | 2024-03-05 | 2024-03-05 | Matched |
| =TEXT(DATE(2024,3,5),"dddd") | Full weekday name format code. March 5, 2024 falls on a Tuesday (verified against a real calendar). | Tuesday | Tuesday | Matched |
Docs & syntax
- Excel: official documentation
- Google Sheets: official documentation
- LibreOffice Calc: official documentation
Related how-to recipes
- How to abbreviate large numbers as K and M
- How to add leading zeros to a number
- How to concatenate a date with text (without getting a number)
- How to convert 12-hour text times to 24-hour
- How to convert a date to text
- How to convert minutes to hours and minutes
- How to convert seconds to hours:minutes:seconds
- How to display a decimal as a fraction
- How to get the month name from a date
- How to get the weekday name from a date
- How to calculate hours between two times
- How to use the TEXT function
- How to stop numbers showing as scientific notation (1.23E+11)