How to use the Excel DOLLAR function

The function CONCATENATE is used to combine values (textual and numerical) from different cells into one. Its analog is & (ampersand). The sign copes with the simplest tasks. But it is not suitable to combine a lot of rows.

Syntax: =DOLLAR( number, [decimal_places] )

The DOLLAR function syntax has the following arguments:

  • Number (Required): A number, a reference to a cell containing a number, or a formula that evaluates to a number.
  • Decimals (Optional): The number of digits to the right of the decimal point. If this is negative, the number is rounded to the left of the decimal point. If you omit decimals, it is assumed to be 2.

Example: Let’s look at some Excel DOLLAR function examples and explore how to use the DOLLAR function as a worksheet function in Microsoft Excel:

Syntax:  =DOLLAR(A2,B2)


Based on the Excel spreadsheet above, the following DOLLAR examples would return:

Syntax: =DOLLAR(A3,B3)
Result: $245.3

Syntax: =DOLLAR(A4,B4)
Result: $250

Syntax: =DOLLAR(A5,B5)
Result: $245.25

Syntax: =DOLLAR(A6,B6)
Result: $200


  • 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.

Add a Comment

Your email address will not be published. Required fields are marked *