CURRENCY (format number as currency)

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