Documentation/How Tos/Calc: DOLLAR function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 07:52, 17 July 2018 by Sancho (Talk | contribs)

Jump to: navigation, search


DOLLAR

Returns text representing a number in your local currency format.

Syntax:

DOLLAR(number; decimals)

returns text representing number as currency. decimals (optional, assumed to be 2 if omitted) sets the number of decimal places.
Tools - Options - Language Settings - Languages - 'Default Currency' sets the currency to be used (normally be the currency of your locale).

Example:

DOLLAR(255)

returns $255.00, if your currency is US dollars.

DOLLAR(367.456; 2)

returns $367.46, if your currency is US dollars.

Issues:

  • Because it depends on local settings, DOLLAR should not be regarded as portable.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_DOLLAR_function&oldid=243410"
Views
Personal tools
Navigation
Tools