Converts a number to text using the currency format, with the decimals rounded to the specified place.
Söz dizimi
DOLLAR(number, [decimals])Bağımsız değişkenler
numberzorunlu
The number or reference to a cell containing a number that you want to convert.
decimalsisteğe bağlı
The number of digits to the right of the decimal point; defaults to 2.
The DOLLAR function formats a number as currency and converts it into a text string. It is useful for displaying values in reports where you want to maintain specific decimal precision while treating the result as text rather than a numeric value.
=DOLLAR(1234.567, 2)→$1,234.57Converts the number to currency format and rounds it to two decimal places.
Select the cell
Click on the cell where you want the formatted text to appear.
Enter the formula
Type =DOLLAR( and select the number you want to format, followed by the desired decimal count.
Finalize
Press Enter to see the result as a text string formatted with a currency symbol.
It returns a text string, which means you cannot perform mathematical calculations on the result directly.