DOLLAR in Excel: Currency Text and Rounding Examples

• Introduced: the first introduction version is not established by the reviewed official history.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official DOLLAR reference. Documentation and independent models; no native Excel execution or wider platform certification.

=DOLLAR(number,[decimals])

A negative decimals argument rounds to places left of the decimal point. Microsoft recommends ordinary cell currency formatting for values that must remain numeric, because DOLLAR produces text. This distinction matters for range-based totals and averages.

The exact strings below use the English/U.S. currency convention illustrated in Microsoft’s reference: dollar sign, comma grouping, decimal point and parentheses for negatives. Other local settings can display another symbol or punctuation. The underlying arithmetic is independently checked; native locale behavior has not been executed.

Enter these numbers in A2:A5:

Use B2 for the formula and fill through B5. The first value rounds to 2468.38; the negative has the same magnitude with the reference’s parenthesized currency style. The last value rounds to 0.13 because the third decimal digit is 6.

In C2, ="Amount: "&B2 produces Amount: $2,468.38. This is an appropriate use of currency text in a label. It is not a numeric amount suitable for a later calculation merely because it looks like one.

Using A2=2468.376:

The default and explicit 2 agree. A count of −1 targets tens and −2 targets hundreds. These controls avoid exact binary midpoint cases, so they do not claim a native tie-breaking test.

For A3=−2468.376, =DOLLAR(A3,-2) gives the modeled U.S.-style text ($2,500). The decimals argument controls rounding precision; it is not a count of significant digits.

Enter 10.004, 10.004 and 10.004 in E2:E4. In F2 use =DOLLAR(E2,2) and fill through F4. Each row displays $10.00.

The sum of the original numeric inputs is 30.012, so:

=DOLLAR(SUM(E2:E4),2)

returns $30.01 under the stated locale. Three individually rounded numerical amounts of 10.00 total 30.00 instead. This one-cent difference comes from the order of rounding, not a missing row.

If a reporting policy requires each row to be rounded before totaling, create a numeric helper in G2 with =ROUND(E2,2) and fill down. =SUM(G2:G4) gives numeric 30. Use currency cell formatting on G, or build a final DOLLAR label from that total. The choice of rounding policy belongs in the report specification; this example does not prescribe an accounting rule.

=ISTEXT(B2) tests TRUE and =ISNUMBER(B2) tests FALSE for the formula-generated currency string. A range containing only those DOLLAR results is text, so SUM does not become a currency-aware parser of that range. Keep numeric source cells available and total them, rather than relying on implicit conversion of display strings.

DOLLAR also has no exchange-rate argument. Showing a local currency symbol beside 100 leaves the number 100; it does not translate an amount held in another currency.

Use ROUND when a rounded number is required, TEXT for an explicit display pattern and FIXED for decimal text without a currency symbol. Empty inputs, invalid precision types and extreme-value error codes are not established by this short reference and are not asserted here. Preserve the original numeric precision unless the intended report explicitly calls for rounding it.

• Microsoft DOLLAR reference.
• Editorial testing standards.

Expected outputs are independently calculated examples or documented rules, not captured native Excel results. Formulas use English function names and comma argument separators. Locale, rendering and boundary restrictions are stated where relevant.