Buzz
Explore more Excel functions beyond DOLLAR, including COUNT, Excel's counting function, and AVERAGE, the function for calculating averages. Mytour offers a plethora of articles for readers to delve into these functions.
Discover the functionality of the DOLLAR function in Excel.
Describing the DOLLAR function in Excel: Converting Text to Currency Symbols
The DOLLAR function in Excel rounds decimal numbers to a specified position and then converts the result into a text string with a currency symbol.
The currency format used adheres to the default format set on the user's computer.
The syntax for the Excel Dollar function is:
DOLLAR( number, [decimals] )
Where:
- Number: The value to be converted into a text string.
- [decimals]: Optional. This parameter is used to specify the position of the number to the right of the decimal point.
Note:
+ If [decimals] is omitted, the default value is 2.
+ If [decimals] is a negative number, the provided value will be rounded to the left of the decimal point.
Example of the DOLLAR function in Excel: Converting Text to Currency Symbols
The spreadsheet below illustrates the use of the Excel Dollar function to convert the number 123.591 into a text string with a currency symbol, rounded to different decimal places.
Formula:
Result Returned:
Note, in cell A1 of the above spreadsheet, the [decimals] parameter is omitted in the Dollar function, so the default value of 2 is used.
Common Errors with Excel's DOLLAR Function: Converting Text to Currency Symbols
If encountering an error with the Excel Dollar function, it may be the #VALUE! error.
- Error #VALUE!: This error occurs if any of the provided arguments are not numeric values.
Some Common Issues with Excel's Dollar Function
During the use of Excel Dollar function, you may encounter the following issues:
Common Issue:
After converting a numeric value into a text string with a currency symbol using the Excel Dollar function, it will be stored in Excel as text and cannot be used in other numerical calculations.
Resolution:
If you want to use currency values in numerical calculations, it's advisable not to use the Excel Dollar function. Instead, simply change the format of the original number to currency format.
The simplest way to achieve this is by selecting the currency symbol button on the Excel Ribbon. Typically, you can find this button in the Number group, under the Home tab on the Ribbon, as shown in the image below:
This article on Mytour has introduced you to the Excel DOLLAR function for converting text to currency symbols. For more detailed information about functions, readers can explore articles on Mytour, such as the AVERAGE function in Excel.
