Exceljet

Quick, clean, and to the point

Excel DOLLAR Function

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 
Excel 2003
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 
Excel TEXT function
Excel TEXT Function

The Excel TEXT function returns a number in a given number format, as text. You can use the TEXT function to embed formatted numbers inside text.

500 Formulas | 101 Functions

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.