Documentation/How Tos/Calc: DOLLAR function

CALC FUNCTIONS

Text Functions

< Previous Section

Next Section >

FUNCTIONS

• Base
• Char
• Clean
• Code
• Concatenate
• Dollar
• Exact
• Find
• Fixed
• Left
• Len
• Lower
• Mid
• Proper
• Replace
• Rept
• Right
• Search
• Substitute
• T
• Text
• Trim
• Upper
• Value

< Previous Page

Next Page >

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

• FIXED

• Text functions

• Functions listed alphabetically
• Functions listed by category