### Excel Formula for Dollar Sign

This Excel Tutorial demonstrates how to use the Excel DOLLAR Function in Excel to convert a number to text and add a dollar sign, with formula examples.

## DOLLAR Function Description:

The DOLLAR Function Converts a number to text and stores the text in currency format.

## Formula Examples: Example Formula Result
Number 1 =DOLLAR(C5,D5) \$52.50
Number 2 =DOLLAR(C6,D6) \$62.00
0 Decimal Places =DOLLAR(C7,D7) \$71

## Syntax and Arguments:

The Syntax for the DOLLAR Formula is:

### Function Arguments ( Inputs ):

number – The number you wish to convert into text formatted as currency.

decimals – OPTIONAL. The number of decimal places to display. Default = 2.

Using the DOLLAR Function will convert the number into a string of text in dollar format. To simply convert the format of the cell, while keeping the number stored as a number, use the Format Cells Dialog Box ( Shortcut: CTRL + 1 ) or make the change in the Home Ribbon. <>.

## DOLLAR Examples in VBA

You can also use the DOLLAR function in VBA. Type:
`application.worksheetfunction.dollar(number,decimals)`
For the function arguments (number, etc.), you can either enter them directly into the function, or define variables to use instead.

`=AND(`  