Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
TEXT
TEXT formats a numeric or date value as a string according to a format code you provide, such as currency, percentage, date patterns, or custom notation. Use it when you need to embed a formatted number inside a concatenated string or display values in a specific regional or presentation format.
Excel
=TEXT(A2,"$#,##0.00")Google Sheets
=TEXT(A2,"$#,##0.00")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Amount |
| 1234.5 |
| 9876.54 |
| 300 |
| 42000.1 |
=TEXT(A2,"$#,##0.00")→$1235,##0.00
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Reference the cell containing the number or date you want to format.
- 2Provide a format code as a text string (e.g., "MM/DD/YYYY", "$#,##0.00", "0.00%").
- 3Enter =TEXT(value, format_text) and combine the result with other strings using CONCAT or &.
Need a version for your data?
Try: “Format sales numbers as dollar amounts with two decimal places inside a sentence”