DOLLAR Function

Summary

The Excel DOLLAR function converts a number into currency-formatted text. For example, =DOLLAR(1234.567,2) returns a formatted result such as "$1,234.57".

DOLLAR is useful when a formula needs to produce a finished text result that looks like money. It is often used in labels, summaries, and sentence-style outputs. The result is text, not a number.

DOLLAR is best thought of as a presentation function. It helps when a workbook needs a polished money value inside a sentence, label, or export string, but it is not the right tool when the result still needs to be reused in arithmetic because the output is text.

Syntax

=DOLLAR(number, [decimals])

number is the value to format. decimals is optional and controls how many decimal places appear. If omitted, Excel uses 2 decimal places.

Arguments

• number - [Required] The value you want to format as currency text.
• decimals - [Optional] The number of decimal places to show. Negative values round to the left of the decimal point.

DOLLAR vs Other Functions

DOLLAR is one of several functions that can produce formatted text. It is convenient when you want a currency-style result without writing a custom format code yourself.

Using DOLLAR

DOLLAR is often used in formulas that produce readable summary text. It lets a sentence include a value that already looks like money, with the symbol and separators in place.

It is important to remember that DOLLAR returns text. If a worksheet still needs the value for math, keep the original number in a separate cell or use the numeric source directly in the calculation.

• Use DOLLAR when a formula result should display a money value as text.
• Use the decimals argument to control whether cents appear.
• Use TEXT instead when you need more control over the exact currency format.

Example 1 - Formatting a Number as Currency Text

This is the direct use of DOLLAR. Excel rounds the value and returns a currency-style text string.

=DOLLAR(1234.567, 2)
// "$1,234.57"

=DOLLAR(1234.567, 0)
// "$1,235"

Example 2 - Rounding to Whole Dollars

If cents are not needed, setting the decimals argument to 0 gives a cleaner summary value.

=DOLLAR(A2, 0)
// 5000.75 -> "$5,001"

Example 3 - Formatting a Negative Amount

Negative values are also returned as text. The exact display style can depend on Excel settings, but the result still behaves as formatted text rather than a number.

=DOLLAR(A3, 2)

Example 4 - Embedding Currency in a Sentence

This is one of the most common DOLLAR patterns. The formula builds a full sentence while keeping the amount formatted like currency.

="The total is "&DOLLAR(A4, 2)
// If A4 = 100, the result is "The total is $100.00"

If the formatted result needs to be added, averaged, or compared numerically later, DOLLAR is not the right final step. Keep the source number for the calculation and use DOLLAR only where the formatted text is needed.

Conclusion Recap

DOLLAR is best when you want a formula to show a money-looking result as text. This lesson showed that it is helpful for labels, sentences, and summary lines where the value should already look like currency when the formula finishes.

The key beginner point is that DOLLAR does not return a real number you can keep calculating with. It returns text. That is why it works well at the display step, but not as the best choice in the middle of a math formula.

• Summary: DOLLAR formats a number as currency text.
• Syntax: =DOLLAR(number, [decimals]).
• Key point: The result is text, not a numeric currency value.
• Practical usage: Labels, summaries, and sentence-style outputs that include money values.
• Best pattern: Use DOLLAR at the final display step, not in the middle of a calculation.