How to Use DOLLAR Function in Excel (with Examples & Tips)

Hello everyone! Today we will learn about a very helpful formatting function in Microsoft Excel: the DOLLAR() function.

The DOLLAR function converts a number to text using currency format, with the decimals rounded to the specified place. It is especially useful when you need to combine numbers formatted as currency with text in the same cell.

🛠️ What is the DOLLAR Function?

The DOLLAR function takes a number and formats it as text using a currency format (like $1,234.56). The currency symbol used depends on your computer's local language settings.

Important Note: Because the result is a text string, you cannot use it directly in mathematical calculations like SUM or AVERAGE anymore!

Formula Syntax:

=DOLLAR(number, [decimals])

• number (Required): The number, reference to a cell containing a number, or a formula that evaluates to a number you want to format.
• decimals (Optional): The number of digits to the right of the decimal point. If omitted, the default is 2. If negative, the number is rounded to the left of the decimal point.

📊 Simple Examples

Here are some straightforward examples to see how the DOLLAR function formats numbers:

🚀 Real World Example: Combining Text and Numbers

The most common reason to use DOLLAR is when you want to write a dynamic sentence combining text and calculated numbers.

If cell A2 contains a total sales amount of 4567.89.

❌ Without DOLLAR:

="Total sales for this month are " & A2

• Result: Total sales for this month are 4567.89 (Missing the currency symbol and comma!)

✅ With DOLLAR:

="Total sales for this month are " & DOLLAR(A2)

• Result: Total sales for this month are $4,567.89 (Beautifully formatted!)

💡 Easy Pro Tips

1. Changing the Currency Symbol: The DOLLAR function uses your system's default currency format. If your computer is set to UK regional settings, it will output £ instead of $. If you need a specific currency regardless of settings, consider using the TEXT function instead, e.g., =TEXT(A2, "$#,##0.00") or =TEXT(A2, "€#,##0.00").
2. Rounding Large Numbers: By using a negative number for the decimals argument, you can quickly round large amounts. =DOLLAR(15499, -3) gives you $15,000!
3. DOLLAR vs Cell Formatting: If you just want to see a dollar sign in a cell, use Excel's normal Number Formatting (Home tab → Number Format). Only use DOLLAR when you need the number to literally become a text string (like when joining with other text).

📚 Useful Resources

• How to Use TEXT Function in Excel + Tips (Video in Khmer)
• How to Use the VALUE Function in Excel (video in khmer) + Tips