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.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
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.