# FIXED

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



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)`

## Version Available

This function is available in product version 1.0 or later.

## See Also

[DOLLAR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDOLLAR) \| [Text Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functstext)