Formula Reference > Spreadsheet Formula Functions

This function rounds a number to the specified number of decimal places, formats the number in decimal format using a period and commas (if so specified), and returns the result as text.

Syntax

FIXED(num,digits,notcomma)

Arguments

This function has these arguments:

Argument	Description
num	Number to round and convert to text
digits	[Optional] Number of decimal places; if omitted, uses two places
notcomma	[Optional] Logical value whether not to use commas; if omitted or FALSE, returns with commas

Data Types

Accepts numeric data for first two arguments; accepts logical value for the third argument. Returns string (text) data.

Examples

FIXED(B3)

FIXED(R3C2,2,FALSE)

FIXED(4.2365,3)