WorksheetFunction.Fixed Method (Excel)

Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.

expression .Fixed(Arg1, Arg2, Arg3)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

Number - the number you want to round and convert to text.

Arg2

Optional

Variant

Decimals - the number of digits to the right of the decimal point.

Arg3

Optional

Variant

No_commas - a logical value that, if TRUE, prevents FIXED from including commas in the returned text.

Return Value

String

  • Numbers in Microsoft Excel can never have more than 15 significant digits, but decimals can be as large as 127.

  • If decimals is negative, number is rounded to the left of the decimal point.

  • If you omit decimals, it is assumed to be 2.

  • If no_commas is FALSE or omitted, then the returned text includes commas as usual.

  • The major difference between formatting a cell containing a number with the Cells command ( Format menu) and formatting a number directly with the FIXED function is that FIXED converts its result to text. A number formatted with the Cells command is still a number.

Show: