writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 2:
Line 2: − + Line 15:
Line 15: − + Line 53:
Line 53: −
no edit summary
*where, <math>num</math> is a number
*where, <math>num</math> is a number
*<math>dec</math> is number of digits to right of decimal point
*<math>dec</math> is number of digits to right of the decimal point
DOLLAR() converts a number to a text using currency format and applies a Dollar currency symbol.
DOLLAR() converts a number to a text using currency format and applies a Dollar currency symbol.
*<math>num</math> can be a number or reference to a cell containing a number.
*<math>num</math> can be a number or reference to a cell containing a number.
*<math>dec</math> specifies the number of digits to the right of decimal point to be displayed in the output.
*<math>dec</math> specifies the number of digits to the right of the decimal point to be displayed in the output.
*If <math>dec</math> is negative, the output is rounded to left of the decimal point.
*If <math>dec</math> is negative, the output is rounded to left of the decimal point.
*If <math>dec</math> is omitted, Calci assumes it to be 2.
*If <math>dec</math> is omitted, Calci assumes it to be 2.
*[[Manuals/calci/BAHTTEXT | BAHTTEXT]]
*[[Manuals/calci/BAHTTEXT | BAHTTEXT]]
==References==
==References==
*[http://en.wikipedia.org/wiki/Dollar Dollar]
*[http://en.wikipedia.org/wiki/Dollar Dollar]