<< Click to Display Table of Contents >> CURRENCY (format number as currency) |
Syntax:
CURRENCY(Number [, n])
Description:
Converts a number to a text string. The text string contains the number, rounded to n decimal places and formatted as a currency.
The currency symbol applied depends on your computer's country settings. For example, in the U.S. a dollar sign $ is applied, in Germany, a euro sign € is applied, etc.
Number is the number to be converted.
n (optional) is the number of decimal places. If n is omitted, Number is rounded to the nearest integer.
If n is a negative value, Number is rounded to the left of the decimal point. For example, if n is -2, Number is rounded to the nearest multiple of hundred (see last example).
Note:
Please keep in mind that the result of this function is a text string. To round a number without converting it to a text string, use one of the round functions (e.g., ROUND) instead.
To display only a number rounded and formatted as currency, you can also change its number format using the commands of the ribbon tab Home | group Number.
Compatibility notes:
This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.
Example:
CURRENCY(123.456) returns the text string $123.46
CURRENCY(123.456, 2) returns the text string $123.46
CURRENCY(123.456, -2) returns the text string $100