# DOLLAR

Formulas / DOLLAR
The DOLLAR function converts a numeric value into a text string formatted as currency, with the default currency symbol and a specified number of decimal places.
DOLLAR(number, [decimals])
• number - The number to be converted to text and formatted as a currency.
• decimals - [OPTIONAL] The number of decimal places to display in the resulting text. If omitted, the default is 2 decimal places.

## Examples

• =DOLLAR(1234.567)

This formula converts the numeric value 1234.567 into the currency-formatted text "\$1,234.57" (assuming the default currency symbol is "\$").

• =DOLLAR(-987.654, 3)

This formula converts the numeric value -987.654 into the currency-formatted text "-\$987.654" with three decimal places, resulting in the text "-\$987.654" (assuming the default currency symbol is "\$").

## Summary

The DOLLAR function formats a numeric value as a currency, rounding it to a specified number of decimal places and adding a currency symbol.

• The DOLLAR function converts a numeric value into a text string formatted as currency, using the default currency symbol for the system.
• The DOLLAR function allows users to specify the number of decimal places to display in the formatted currency string.
• The DOLLAR function is useful for displaying numeric values as currency in reports, dashboards, and financial statements.