Free TEXT Formula Generator (2026) — Format Numbers as Text
Converts a value to text in a specific number format.
Common Errors & Fixes
Result shows #####
Causes:- Column too narrow for the formatted text output.
- Custom format code is invalid or mistyped.
Fixes:- Widen the column.
- Double-check the format string syntax — it must be in quotes.
Frequently Asked Questions
What is the most useful TEXT format code?
"$#,##0.00" for currency, "YYYY-MM-DD" for dates, "0.0%" for percentages, and "00000" for leading zeros (like ZIP codes).
Why is my formatted number not calculating in formulas?
TEXT converts numbers to text, which other formulas may not recognize as numeric. Use the original cell for calculations and TEXT only for display/output.
Can TEXT format dates in Google Sheets?
Yes. TEXT works identically in Google Sheets. Format codes are the same: "MM/DD/YYYY", "DDD" for abbreviated day name, "MMMM" for full month name.
Related Formulas
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More