Excel DOLLAR Function
Summary
The Excel DOLLAR function converts a number to text using the Currency number format. The TEXT function can do the same thing, and is much more versatile.
Purpose
Convert a number to text in currency format
Return value
A number as text in currency format.
Syntax
=DOLLAR (number, decimals)
Arguments
- number - The number to convert.
- decimals - The number of digits to the right of the decimal point. Default is 2.
Version
Usage notes
- The DOLLAR function converts a number to text using currency number format: $#,##0.00_);($#,##0.00).
- The default for decimals is 2. If decimals is negative, number will be rounded to the left of the decimal point.
- The name of the function and the currency symbol used is based on language settings of the computer.
- The TEXT function is a more flexible way to achieve the same result.
Related functions
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
