Skip to content
Excel

DOLLAR function in Excel

Converts a number to text, using the $ (dollar) currency format

=DOLLAR(number, [decimals])

DOLLAR syntax and parameters

Two arguments, one required.

  • numbernumberRequired

    A number, a reference to a cell containing a number, or a formula that evaluates to a number.

  • decimalsnumberOptional

    The number of digits to the right of the decimal point. If this is negative, the number is rounded to the left of the decimal point. If you omit decimals, it is assumed to be 2.

DOLLAR examples

Formulas you'll actually reuse.

  1. A number as currency text, two decimals by default:

    =DOLLAR(B2)

    Result"$1,250.00"

  2. Negative decimals round left of the point — here to the nearest thousand:

    =DOLLAR(B2, -3)

    Result"$1,000"

DOLLAR in Google Sheets

Same name — your formula ports as-is.

Try DOLLAR in the playground

Edit the example — nothing to install.

Preloaded with the DOLLAR formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.