Skip to content
Google Sheets

DOLLAR function in Google Sheets

Formats a number into the locale-specific currency format.

=DOLLAR(number, [number_of_places])

DOLLAR syntax and parameters

Two arguments, one required.

  • numbernumberRequired

    The value to be formatted.

  • number_of_placesnumberOptional

    [ OPTIONAL - 2 by default ] - The number of decimal places to display.

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 Excel

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 Google Sheets gets this done.