Products, services, and OS functions
may not be available in this country.

CURRENCYCODE

The CURRENCYCODE function returns the currency code of a given currency value, or the currency code for the language and region set for the computer or for the current document.

CURRENCYCODE(value)

value: An optional currency value for which the currency code is to be returned. If value is omitted, the default currency code for your language and region is returned.

Notes

  • Currency codes are defined by ISO 4217, a standard published by the International Organization for Standardization. You can find the ISO currency codes on the web.

  • The default currency code depends on your Language & Region settings (in System Preferences in macOS 12 and earlier, System Settings in macOS 13 and later, and Settings in iOS and iPadOS). To change this setting for a document in macOS, choose File > Advanced > Language & Region in the open document, or, when you create the document, choose an option from the Language pop-up menu in the Template Chooser.

Examples

=CURRENCYCODE(5) returns "USD" if your language and region setting is English (United States).

=CURRENCYCODE(B2) returns "CNY," the currency code for the Chinese Yuan, if cell B2 contains ¥12 and your language and region setting is Chinese (Simplified, China mainland).

=CURRENCYCODE() returns "EUR," the currency code for France, if your language and region setting is French (France).

=CURRENCYCODE("£6") returns "GBP," the currency code for the British Pound, if your language and region setting is English (United Kingdom).

See alsoCURRENCYCURRENCYCONVERT
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.