[PDF]Dollar Function In Excel

Imparting knowledge

Gyan Sangrah

Dollar function in excel

In this article, we will discuss dollar function in excel.

Purpose

The function converts number into a dollar format.

Syntax

Dollar (Number, [Decimal])



In the above syntax

1. The first parameter is the number to convert into dollar format.

2. Second parameter is an optional parameter that specifies the number of digits displayed
after decimal.

Example



DOLLAR( 12.299555,2)

Equals to

$12.30



DOLLAR! 12.044,0)

Equals to

$12