| =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 |