DOLLAR Function in Excel

In this post, let’s learn how the DOLLAR Function works in Excel, describe the formula syntax, and how you can use the DOLLAR Function in an Excel spreadsheet.  

What is the DOLLAR Function in Excel?  

The DOLLAR function in excel is used to convert numbers to text using currency format, also it is one of the text functions.   

Syntax of DOLLAR Function in Excel  

=DOLLAR(number, decimals)  

Parameter  

  • Number- The number to be formatted.  
  • Decimals-Optional. The number of digits to be displayed on the right of the decimal point. The default value of the decimal is 2. If the decimal value is negative the number will be rounded to the right of the decimal point.  

Example  

=DOLLAR(A1,2)  

=DOLLAR(A2,-2)  

How to use the DOLLAR function in Excel?  

The following steps will explain the work of the DOLLAR function in an excel spreadsheet:  

First, prepare an excel sheet with the specified details in it to perform DOLLAR Function  

  • we use the =DOLLAR(A1,2) to convert a numeric value to text string, currency format.
  • you can also use this method to perform DOLLAR function, after typing “=DOLLAR(” without leaving the cell use the shortcut key CTRL+A, to open the “function arguments” dialog box.
How to use the DOLLAR function in Excel?

we can also use DOLLAR function in VBA, by typing:

application.worksheetfunction.dollar(number,decimals)

Note:  

  • The Function name and the currency symbol used are based on the language settings of the computer.    
  • The DOLLAR function returns #VALUE! when the passed arguments are non-numeric.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...