This Excel tutorial explains how to use the Excel DOLLAR function with syntax and examples.
Microsoft Excel 2019. Formulas and Functions. Formula limits in Excel 2019. Pasting a name into a formula. The Microsoft Excel DOLLAR function converts a number to text, using a currency format. The format used is $#,##0.00);($#,##0.00). The DOLLAR function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel.
Description
The Microsoft Excel DOLLAR function converts a number to text, using a currency format. The format used is $#,##0.00_);($#,##0.00).
The DOLLAR function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the DOLLAR function can be entered as part of a formula in a cell of a worksheet.
Syntax
The DOLLAR function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the DOLLAR function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the DOLLAR function in Microsoft Excel is:
Parameters or Arguments
Microsoft Excel 2019 16 34 Coupe
- number
- The number to convert to text.
- decimal_places
- Optional. It is the number of decimal places to display. The number will be rounded accordingly.
Returns
The DOLLAR function returns a string/text value.
Applies To
- Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
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 Excel spreadsheet above, the following DOLLAR examples would return:
Frequently Asked Questions
Question: In Microsoft Excel, my question concerns formatting numbers in a particular cell. For example, the cell says:
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)
This formula should now return something like:
MO-200: Microsoft Excel (Excel and Excel 2019)
Microsoft Excel 2019 16 34 Coupes
Languages: en en-my nl fr de id-id ko pt-br es it ru ja pl el-gr zh-cn zh-tw ar-sa
Retirement date:
This exam measures competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects. The exam covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data entry logs.
Price based on the country in which the exam is proctored.
for Microsoft Excel (Excel and Excel 2019)All objectives of the exam are covered in depth so you'll be ready for any question on the exam.
