# DOLLAR

## 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* | [Required] 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.

## 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