This Excel tutorial explains how to use the Excel DOLLAR function with syntax and examples.
decimal_places is optional. It is the number of decimal places to display. The number will be rounded accordingly.
Based on the spreadsheet above, the following Excel DOLLAR examples would return:
Answer: Even though your cell is formatted with a number format, your formula is returning text not a numeric value so the number format will not be applied. You will need to apply the format to the number inside of the formula.
You could try using the DOLLAR function to apply the format as follows: (you will need to remove your $ sign because the DOLLAR function will insert one automatically)
Description
The Microsoft Excel DOLLAR function converts a number to text, using a currency format. The format used is $#,##0.00_);($#,##0.00).Syntax
The syntax for the Microsoft Excel DOLLAR function is:DOLLAR( number, [decimal_places] )
Parameters or Arguments
number is the number to convert to text.decimal_places is optional. It is the number of decimal places to display. The number will be rounded accordingly.
Applies To
The DOLLAR function can be used in the following versions of Microsoft Excel:- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Excel Function
The DOLLAR function can be used in Microsoft Excel as the following type of function:- Worksheet function (WS)
Example (as Worksheet Function)
Let's look at some Excel DOLLAR function examples and explore how to use the DOLLAR function as a worksheet function in Microsoft Excel:Based on the spreadsheet above, the following Excel DOLLAR examples would return:
=DOLLAR(A1, 0) Result: "$120" =DOLLAR(A1, 2) Result: "$120.10" =DOLLAR(A2, 1) Result: "$52.1" =DOLLAR(1345, 2) Result: "$1,345.00" =DOLLAR(A1+A2, 2) Result: "$172.10"
Frequently Asked Questions
Question: In Microsoft Excel, my question concerns formatting numbers in a particular cell. For example, the cell says:="Gas price: $" & CHOOSE(gas.deck, B1, B2, B3) & "per mmbtu"But returns $3 when the cell is formatted to two decimals. If the price were $3.25, the correct price would show. Any help would be greatly appreciated.
Answer: Even though your cell is formatted with a number format, your formula is returning text not a numeric value so the number format will not be applied. You will need to apply the format to the number inside of the formula.
You could try using the DOLLAR function to apply the format as follows: (you will need to remove your $ sign because the DOLLAR function will insert one automatically)
="Gas price: " & DOLLAR(CHOOSE(gas.deck, B1, B2, B3)) & "per mmbtu"This formula should now return something like:
Gas price: $3.25per mmbtu
