FIXED

The number you want to round and convert to text. For example: 1234.5678, -987.654, or A1.

The number of decimal places to display:

• Positive number - Number of decimal places to show

• 2 (default) - Two decimal places

• 0 - No decimal places (integer)

• Negative number - Round to left of decimal point

Whether to include thousands separators:

• FALSE (default) - Include commas as thousands separators

• TRUE - Omit thousands separators

FIXED converts a number to text format with consistent decimal places. When no_commas is FALSE or omitted, it includes thousands separators (commas). When TRUE, it omits the separators. Negative decimals parameter rounds to the left of the decimal point (e.g., -1 rounds to nearest 10). The result is always text, not a number.