How to How to Use DOLLAR Function in Excel in Excel - Practical Guide

Learn to use the DOLLAR function to convert numbers into text formatted as currency with a specified number of decimal places. This function is essential for creating professional financial reports, invoices, and statements where currency formatting needs to be embedded in formulas rather than applied through cell formatting alone.

Why This Matters

The DOLLAR function ensures consistent currency formatting across reports and prevents formatting loss when exporting data to other systems.

Prerequisites

•Basic understanding of Excel formulas and syntax
•Familiarity with cell references and numerical data
•Knowledge of currency formatting concepts

Step-by-Step Instructions

Open Excel and prepare your data

Launch Excel and create a spreadsheet with numerical values in column A that you want to convert to currency format (e.g., amounts like 1500, 2750.50).

Click on the target cell

Select an empty cell in column B where you want the DOLLAR-formatted result to appear (e.g., cell B1).

Enter the DOLLAR formula

Type the formula =DOLLAR(A1, 2) where A1 is your number and 2 specifies two decimal places. Press Enter to execute the formula.

Copy the formula to other cells

Select cell B1, copy it (Ctrl+C), then select the range B2:B10 and paste (Ctrl+V) to apply the formula to all corresponding values.

Verify the results

Check that all values now display as currency text with dollar signs and the specified decimal places (e.g., $1,500.00).

Alternative Methods

Using TEXT function

Use =TEXT(A1, "$#,##0.00") as an alternative to DOLLAR for more flexible currency formatting with custom locale support.

Applying cell formatting directly

Format cells as currency using Home > Number Format > Currency dropdown without using DOLLAR function if text conversion isn't needed.

Tips & Tricks

✓Use negative numbers as the second parameter to round without displaying decimals: =DOLLAR(A1, -1) rounds to nearest 10.
✓DOLLAR always returns text, not numbers, so use it only when you need currency text for reports or labels.
✓Combine DOLLAR with CONCATENATE to create detailed financial statements: =CONCATENATE("Total: ", DOLLAR(A1, 2))

Pro Tips

★Wrap DOLLAR in VALUE function when you need numeric results: =VALUE(DOLLAR(A1, 2)) converts text back to number.
★Use DOLLAR with IF statements to conditionally format values: =IF(A1>0, DOLLAR(A1, 2), "Pending") for dynamic reporting.
★Leverage DOLLAR in data validation to ensure consistent currency presentation across large datasets and multiple worksheets.

Troubleshooting

Formula returns #NAME? error

Ensure DOLLAR is spelled correctly and you're using the proper syntax =DOLLAR(number, decimals). Check that your Excel language settings match your formula language.

Currency symbol is wrong (€ instead of $)

DOLLAR always displays $ symbol based on your system locale. Use TEXT function instead for different currency symbols: =TEXT(A1, "€#,##0.00").

Results can't be used in calculations

DOLLAR outputs text, not numbers. Wrap results with VALUE() function to convert back to numbers for arithmetic: =VALUE(DOLLAR(A1, 2))+10.

Related Excel Formulas

TEXT VALUE FORMAT CONCATENATE IF

Frequently Asked Questions

What is the difference between DOLLAR and TEXT functions?

DOLLAR is specifically designed for US currency and always returns text with $ symbol and thousands separators. TEXT offers more flexibility with custom formats and multiple currency symbols. Use DOLLAR for simple US currency conversion and TEXT for international currencies.

Can DOLLAR handle negative numbers?

Yes, DOLLAR displays negative numbers with a minus sign or in parentheses depending on your locale settings. For example, =DOLLAR(-500, 2) returns "-$500.00".

Why does DOLLAR return text instead of numbers?

DOLLAR returns text because it's designed primarily for display purposes in reports and labels. If you need numeric results for calculations, convert the result back using the VALUE function.

Does DOLLAR work in Excel online?

Yes, DOLLAR function works identically in Excel Online, Excel 365, and desktop versions.