Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert a number to text in Excel and Google Sheets
Excel & Google Sheets
=TEXT(A2,"#,##0.00")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Number | As Text |
| 1234.5 | =TEXT(A2,"#,##0.00") |
| 9876 | =TEXT(A3,"#,##0.00") |
| 0.075 | =TEXT(A4,"0.00%") |
| 42000 | =TEXT(A5,"$#,##0") |
=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
Step by step
- 1Select the cell where you want the text result to appear.
- 2Enter =TEXT(A2,"#,##0.00") replacing A2 with the cell containing your number.
- 3Change the format string to match your needs: "0" for integers, "$#,##0.00" for currency, "0.00%" for percentages.
- 4Press Enter. The number is now a text string formatted as specified.
Tips
- To concatenate a number with text without losing formatting, use TEXT: ="Total: "&TEXT(A2,"#,##0.00") instead of ="Total: "&A2.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Why does my formula return a number that still looks like a number?
TEXT always returns a text string. If the cell is still calculating like a number, check you used TEXT() correctly and not VALUE(). The result will be left-aligned by default, indicating it is text.
Can I convert a number to text without any formatting?
Yes. Use =TEXT(A2,"0") for no decimals or =TEXT(A2,"@") in some versions. Alternatively, concatenate with an empty string: =A2&"" converts the number to plain text.