[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

FIXED

Syntax:

FIXED ( number [ , [ num-decimal ] [ , suppress-commas-flag ] ] )

Description: Produces a string containing number rounded to num-decimal decimal places. Thousands separator commas are included as determined by suppress-commas-flag.

Arguments:

Name

Type

Description

number

number

Designate the number that is to be formatted, truncated to integer.

num-decimal

number

Designate the number of decimal places to be used in the resulting string. If negative, number is rounded to the left of the decimal point. If omitted, a value of 2 shall be assumed.

suppress-commas-flag

logical

If TRUE, commas are not included; if FALSE or omitted, commas are included.

 

Return Type and Value: text – The string containing number rounded to num-decimal decimal places.

[Example:

FIXED(1234567) results in 1,234,567.00
FIXED(1234567.555555,4,TRUE) results in 1234567.5556
FIXED(.555555,10) results in 0.5555550000
FIXED(1234567,-3) results in 1,235,000

end example]