# DOLLAR

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 converts a number to text using currency format, with the decimals rounded to the specified place.

## Syntax

DOLLAR(*value*,*digits*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *value* | Numeric value to convert to text using the currency format |
| *digits* | [Optional] Number of decimal places to maintain; if negative, the value is rounded to the left of the decimal point; if omitted, the function rounds to two decimal places |

## Remarks

This function uses the current regional Windows settings to determine the format of the returned string.

## Data Types

Accepts numeric data for both arguments. Returns string data.

## Examples

`DOLLAR(B5,D2)`
`DOLLAR(R5C2,R2C4)`
`DOLLAR(1234.5678,3)` gives the result $1,234.568
`DOLLAR(123.45,1)` gives the result $123.5

## Version Available

This function is available in product version 1.0 or later.

## See Also

[DOLLARDE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDOLLARDE) \| [DOLLARFR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDOLLARFR) \| [FIXED](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionFIXED) \| [Text Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functstext)