This post will guide you how to use Excel DOLLAR function with syntax and examples in Microsoft excel.
Description
The Excel DOLLAR function converts a number to text using currency format (such as: $ symbol), the currency format used depends upon your default language setting on your computer.
The DOLLAR function is a build-in function in Microsoft Excel and it is categorized as a Text Function.
The DOLLAR function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.
Syntax
The syntax of the DOLLAR function is as below:
= DOLLAR (number, [decimals])
Where the DOLLAR function arguments are:
number -This is a required argument. The number to be converted into text string. Or a reference to a cell that containing a number.
Decimals-This is an optional argument. It will specify the number of decimal places to be displayed after decimal point.
Note: If Decimals value is omitted, it is set to be 2 by default. If Decimals value is negative, the number is rounded to the left of the decimal point.
Example
The below examples will show you how to use Excel DOLLAR Text function to convert a number as text using currency format.
#1 To convert Number value in B1 cell to a text string of a currency format and keep 2 digits to the right of the decimal point, just using DOLLAR(B1,2) formulas.

#2 To Display the number in B2 in a currency format and keep 2 digits to the left of the decimal point, using excel formula: DOLLAR(B2,-2)

Related Posts
Get full File Name (workbook and worksheet) and Path
In excel, you can get the current workbook name and it is absolute path using the CELL function. Just refer to the following formula: =CELL("filename",B1) Enter the above formula into any of cells in the current worksheet, then you will ...
Get the Current Worksheet Name only
If you want to get the current worksheet name only in excel, you can use a combination of the MID function, the CELL function and FIND function. You can use the below generic formula: =MID(CELL("filename",B1),FIND("]",CELL("filename",B1))+1,255) The below explains how the ...
Data Validation for Specified Text only
If you want to check if the values that contain a specified text string in one cell, you can use a combination of the FIND function and ISNUMBER function as a formula in the Data Validation. Data Validation for Specified ...
Get the Current Workbook Name
This post explains how to get the current workbook name in excel. Get the Current Workbook Name In excel, the CELL function can get the information of the current worksheet, it will return the full file name and its path. ...
Split Text and Numbers in Excel
This post explains how to split text and numbers in excel, or how to extract the text characters from another strings with text and numbers combined. Split Text and Numbers If you want to split text and numbers, you can ...
Split Text String by Line Break in Excel
In the previous post, we talked that how to split text string by a specified character in excel. And this post will guide you how to split text string by Line Break character. The difference is that you can type ...
Excel Replace Function Remove Text String
This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you ...