TRUECALC
Functions

FIXED

Format number as text with fixed decimal places

Try it

When to use it

When should I use FIXED instead of TEXT?

Use FIXED when you need a number formatted as text with a specific number of decimal places and optional comma separators, without needing a full custom format string.

Used in

operations

Syntax

FIXED(number, [decimals], [no_commas])

On this page