deepcalc
DocsTEXT

TEXT

View as markdown/docs/functions/text.md Ask Claude about this pageOpens Claude with this page's address

Formats number as text with given format.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Text

Examples

=TEXT(0.285, "0.0%")
Result 28.5%

Syntax

TEXT(value, format_text)
value
any required
format_text
text required
ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.