Navigation:  Formula Reference > Spreadsheet Formula Functions >

FIXED

Previous pageReturn to chapter overviewNext page

 

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)

 

See Also

DOLLAR