If you are looking for some special tricks to know how to use the **DOLLAR function **in **Excel**, you’ve come to the right place. We’ll show **5** suitable examples to use the **DOLLAR **function in Excel. This article will discuss every step of the examples. Let’s follow the complete guide to learn all of this.

**Table of Contents**hide

## Download Practice Workbook

Download this practice workbook to exercise while you are reading this article. It contains all the datasets in different spreadsheets for a clear understanding. Try it yourself while you go through the whole process.

## DOLLAR Function: Summary & Arguments

**Summary:**

**DOLLAR** function is a** TEXT** function for converting numbers to text using currency format with decimal points rounded to the specified number. There is no set currency symbol for the Dollar. It depends on your local language settings whether it uses (**$#,##0.00_**);(**$#,##0.00**) number format.

**Syntax:**

The syntax of the **Dollar** function is as follows:

`=DOLLAR(number, [decimals])`

**Arguments:**

Argument |
Required/Optional |
Explanation |
---|---|---|

number |
Required | References to cells that contain numbers, and formulas that evaluate into numbers. |

[Decimals] |
Optional | After the decimal point, the number of digits is listed. In the case of a negative number, the decimal point is rounded to the left. The decimal point is assumed to be two if you want to omit the decimal point. |

**Return Value:**

This application converts a number into text in the form of a currency.

**Available in Version:**

Office 365 ￭ Excel 2019 ￭ Excel 2016 ￭ Excel 2013 ￭ Excel 2011 for Mac ￭ Excel 2010 ￭

Excel 2007 ￭ Excel 2003 ￭ Excel XP ￭ Excel 2000.

## 5 Suitable Examples to Use DOLLAR Function in Excel

The following section demonstrates the use of the **DOLLAR function** in Excel using five practical and tricky examples. The following dataset contains two columns that we will use for demonstration purposes. The number column contains the number, and the Result column contains the result of the converted text.

You should learn and apply these to improve your thinking capability and Excel knowledge. We use the **Microsoft Office 365** version here, but you can utilize any other version according to your preference.

### 1. Convert Number into Text

In the first illustration, we’ll show how to use the **DOLLAR** function to convert a number into text. In this case, we won’t enter any numbers in the argument. The function will therefore convert a number into text with a two-digit decimal point. Let’s walk through the following steps to do the task.

**📌 Steps:**

- First, write down the following formula in cell
**D5**.

**=DOLLAR(B5)**

- Then, press
**Enter**. - Therefore, you will get the following output.

- Next, drag the
**Fill Handle**icon to fill the other cells with the formula. - Consequently, you will be able to convert numbers into text with two-digit decimal points.

**Read More: ****How to Use Database Functions in Excel (With Examples)**

### 2. Get Number in Text with Decimal Points Format

Here, we’ll show you how to use the **DOLLAR** function to get numbers in text with decimal point formatting. To accomplish this, we must enter a number in the **DOLLAR** function’s argument option.

**📌 Steps:**

- First, write down the following formula in cell
**D5**.

`=DOLLAR(B5,4)`

Here, we enter **4** in the **DOLLAR** function’s argument to get a text with the four-digit decimal point.

- Then, press
**Enter**. - Therefore, you will get the following output.

- Afterward, drag the
**Fill Handle**icon to fill the other cells with the formula. - Consequently, you will be able to get a text with a four-digit decimal point.

**Read More: ****How to Use DCOUNT Function in Excel (5 Suitable Examples)**

### 3. Transform Number to Text Without Decimal Point

In this method, we will show how to transform numbers into text without a decimal point. In order to do so, we have to enter zero into the argument option of the **DOLLAR** function. Let’s follow the following steps to do the task.

**📌 Steps:**

- First, write down the following formula in cell
**D5**.

`=DOLLAR(B5,0)`

- Then, press
**Enter**. - Therefore, you will get the following output.

- Next, drag the
**Fill Handle**icon to fill the other cells with the formula. - Consequently, you will be able to transform numbers into text without a decimal point.

**Read More: ****Can Excel DGET Return Multiple Records [See 4 Solutions]**

### 4. Use DOLLAR Function with Negative Argument

Now, we will show how to use the **DOLLAR** function with a negative argument. If we specify a negative argument, numbers will be rounded to the left of the decimal point. In order to do so, we have to enter negative numbers into the argument option of the **DOLLAR** function. Let’s follow the below steps.

**📌 Steps:**

- First, write down the following formula in cell
**D5**.

`=DOLLAR(B5,-1)`

- Then, press
**Enter**. - Therefore, you will get the following output.

- Next, drag the
**Fill Handle**icon to fill the other cells with the formula. - Consequently, you will be able to transform numbers into text with a negative argument.

**Read More: ****How to Determine If a Number Is Even in Excel (4 Suitable Ways)**

### 5. Join Text with Excel DOLLAR Function

In this last example, we will demonstrate how to join text with the Excel **DOLLAR** function. Follow the following process.

**📌 Steps:**

- First, write down the following formula in cell
**D5**.

`="Total Amount " & DOLLAR(B5)`

- Then, press
**Enter**. - Therefore, you will get the following output.

- Next, drag the
**Fill Handle**icon to fill the other cells with the formula. - Consequently, you will be able to join text with the currency format of the number as shown below.

## 💬 Things to Remember

✎ A non-numeric argument will result in an **#VALUE!** error.

✎ After converting a number with the Excel Dollar function, it is saved in Excel as text. As a result, it can’t be employed in numerical computations.

## Conclusion

That’s the end of today’s session. I strongly believe that from now on you may know how to use the** DOLLAR** function in Excel. If you have any queries or recommendations, please share them in the comments section below. Don’t forget to check our website **Exceldemy.com** for various Excel-related problems and solutions. Keep learning new methods and keep growing!