This Excel tutorial explains how to use the Excel DOLLAR function with syntax and examples.
So far, we have discussed the built-in features that can be used to change text to number in Excel. In many situations, a conversion can be done even faster by using a formula. Convert string to number in Excel. Microsoft Excel has a special function to convert a string to number - the VALUE function. The function accepts both a text.
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 syntax for the DOLLAR function in Microsoft Excel is:
Parameters or Arguments
- 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:
The Zoom H6 is a great audio device for video DSLR, but it's also a great audio interface for your Mac or PC, making it a great multipurpose device. Use the scroll switch to select PC/Mac to power the H6 via USB, PC/Mac using battery power to run the H6 off the batteries, or iPad using battery power to connect to an iPad and run the H6 off the batteries.Note: If your computer does not supply enough power to the H6 through USB while using phantom power, select “PC/Mac using battery power.”. H6 setup for mac. The Zoom H6 is a powerful recorder that can be used as an audio interface with your computer or iPad. Read below to setup your H6. Interface Setup. Press the Menu button located on the side of the device. Use the scroll switch to select USB and then press the scroll switch. This tutorial shows how to move files from the Zoom H6 to both Mac & PC. H6 Operation Manual (English) H6 Warranty Registration Card. Compatible Application Software. H6 Compatible SDHC/SDXC Cards. H6 System Software. H6 System Version 2.30. H/F Series ASIO Driver.
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: