fx =TEXT(A1,"$#,##0.00")ABCJohnSmithJohn SmithJaneDoeJane DoeAlexWongAlex Wong
📝 Text

TEXT Formula for Text Manipulation

Format a number as text with a specific format. Copy-paste ready for Excel, Google Sheets, and Airtable.

=TEXT(A1,"$#,##0.00")
When you need this: When you need to display a revenue number (1234.5 in A1) as formatted currency text ("$1,234.50") in a report.

How it works

  1. 1The TEXT function converts a number (A1) to text with a specific format ("$#,##0.00").
  2. 2$ = currency symbol, #,##0 = thousands separator, .00 = 2 decimal places.
  3. 3Useful for labels, reports, and concatenation.

Variations

Format date as text
=TEXT(A1,"MMMM DD, YYYY")
Format percentage
=TEXT(A1,"0.00%")

Related Formulas

CONCATENATE / TEXTJOIN — Join text from multiple cellsTextLEFT / RIGHT / MID — Extract part of a text stringTextLEN — Count the number of characters in textTextTRIM — Remove extra spaces from textText

Need a formula that's not here?

Generate custom formula →