Go Back

Excel DOLLAR Function

While using Excel worksheet, the excel DOLLAR function is used to transform any number to text employing Currency number format. The same result can be also achieved through TEXT function.

Formula

The formula for excel DOLLAR function is given below:

=DOLLAR(number, decimals)

Explanation

A number represents any number which we want to convert. Whereas, decimals shows the total number of digits present on the right side of the decimal point. Its DEFAULT value is 2.

Example:

B4:B8 range contains a number we want to convert into currency format using DOLLAR function. Then the formula is inserted in cells C4:C6 to get results (See screenshot).

Figure 1 Example of Excel Dollar Function

Notes

  • 2 is the default value for decimals. In cases when number have negative decimal places then rounding will take place on the left side of decimal point.
  • The function name and currency symbol employed is conditional to a language used by the computer.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I need a formula to divide a dollar amount by a number of months and then roundup the answer to the nearest dollar.
Solved by V. J. in 21 mins
Hello, I am trying to find the formula to use in excel that converts a weekly, fortnightly, quarterly or annually dollar value into a monthly dollar value. Are you able to please help with this?
Solved by Z. B. in 24 mins
in excel I have one cell that puts in a date instead of a dollar amount which is what I want. all other cells in this row are putting in my dollar amounts
Solved by O. D. in 23 mins

Leave a Comment

avatar