deepcalc
DocsFIXED

FIXED

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

Formats a number as text with a fixed number of decimals.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Text

Examples

=FIXED(1234.567, 1)
Result 1,234.6

Syntax

FIXED(number, [decimals], [no_commas])
number
number required
decimals
number optional defaults to 2
no_commas
boolean optional
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.