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.

See Also

TO_DOLLARS: Converts a provided number to a dollar value.

Examples

true
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.

Search
Clear search
Close search
Google apps
Main menu
9416968889064470442
true
Search Help Center
true
true
true
true
true
35
false
false