Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

# FIXED function

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.

## Syntax

**FIXED**(**number**,**decimals**,**no_commas**)

**Number** is the number you want to round and convert to text.

**Decimals** is the number of digits to the right of the decimal point.

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

## Remarks

- If decimals is negative, number is rounded to the left of the decimal point.
- If you omit decimals, your system locale setting will be used to determine the number of decimal places.
- If no_commas is FALSE or omitted, then the returned text includes commas as usual.

## Examples

Formula |
Description (Result) |
---|---|

=FIXED(1234.567, 1) | Rounds the first number 1 digit to the right of the decimal point (1,234.6) |

=FIXED(1234.567, -1) | Rounds the first number 1 digit to the left of the decimal point (1,230) |

=FIXED(-1234.567, -1, TRUE) | Rounds the second number 1 digit to the left of the decimal point, without commas (-1230) |

=FIXED(44.332) | Rounds the third number 2 digits to the right of the decimal point (44.33) |

Applies to:

SharePoint Server 2007, Windows SharePoint Services 3.0, Deployment Center 2003