ExcelTextBeginner

DOLLAR

Converts a number to text format, applying a currency symbol and specified decimal places.

Read the syntaxReview worked examplesOpen the spreadsheet app
=DOLLAR(number, [decimals])
Open Spreadsheet Explorer

This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.

What the function does

Overview

Converts a number to text format, applying a currency symbol and specified decimal places.

The DOLLAR function converts a numeric value into a text string formatted as currency. It automatically applies the currency format for your locale, including the currency symbol (e.g., "$", "�"), comma separators, and a specified number of decimal places. This function is particularly useful for displaying financial figures in a user-friendly, standardized text format. The `number` argument is the value you want to format. The optional `decimals` argument specifies the number of digits to the right of the decimal point; if omitted, it defaults to 2. If `decimals` is negative, the number is rounded to the left of the decimal point. The output of DOLLAR is a text string, meaning it cannot be directly used in mathematical calculations. For calculations, it's best to keep numbers in their numeric format and apply currency formatting via cell formatting options. DOLLAR is ideal for generating reports or labels where the final output needs to be a formatted string for display purposes.

Quick reference

Syntax

=DOLLAR(number, [decimals])

Inputs

Arguments

numberA number, a reference to a cell containing a number, or a formula that evaluates to a number.
Example: A2
decimals (optional)[Optional] The number of digits to the right of the decimal point. Defaults to 2.
Example: 0

Formula patterns

Examples

1

Formatting a number as currency with default decimals

=DOLLAR(1234.567)
currency formattingfinancial text
2

Formatting a number as currency with zero decimals

=DOLLAR(5000, 0)
reportingtext output

Avoid these issues

Common Errors

1

#VALUE!

Cause: The 'number' argument is not a valid numeric value.

Fix: Ensure 'number' is a numeric value or a reference to a cell containing a number.

2

#NAME?

Cause: The function name is misspelled.

Fix: Correct the spelling of DOLLAR.

Platform support

Compatibility

Excel 2007+Google Sheets

Available in Excel 365 and earlier versions.

Source: Microsoft Support

Common questions

Frequently Asked Questions

Converts a number to text format, applying a currency symbol and specified decimal places.

number: A number, a reference to a cell containing a number, or a formula that evaluates to a number. decimals: [Optional] The number of digits to the right of the decimal point. Defaults to 2.

#VALUE!: Ensure 'number' is a numeric value or a reference to a cell containing a number. #NAME?: Correct the spelling of DOLLAR.