Excel functions / Text

DOLLAR function

A number as text in currency style: $1,234.57, with negatives in brackets.

Syntax

=DOLLAR(number, [decimals])

Arguments

When to use it

DOLLAR turns a number into text in currency format, rounded to the decimals you choose. It is a shortcut for TEXT with a currency format, for building sentences that mention an amount.

Examples

  1. An amount in a sentence

    ABC
    1Total
    21234.5Total due: $1,234.50

    In C2: ="Total due: " & DOLLAR(A2) → Total due: $1,234.50

    Try this example

  2. Rounded to whole dollars

    ABC
    1Total
    21234.5$1,235

    In C2: =DOLLAR(A2, 0) → $1,235

    Try this example

Common mistakes

DOLLAR in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try DOLLAR in the playground

Related functions