DOLLAR

Formats a number into the locale-specific currency format.

Sample Usage

DOLLAR(1.2351,4)

DOLLAR(2.35)

Syntax

DOLLAR(number, [number_of_places])

number - The value to be formatted.
number_of_places - [ OPTIONAL - 2 by default ] - The number of decimal places to display.

Notes

The currency format used by DOLLAR is specific to your spreadsheet locale.
DOLLAR differs from the related function TO_DOLLARS in that DOLLAR outputs text rather than applying a cell format to a number.

Examples

Need more help?

Try these next steps:

Post to the help community Get answers from community members

Text

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search

Close search

Google apps

Main menu