CURRENCY Function

The CURRENCY function inserts the currency symbol, specified in the Regional Settings dialog of Windows, into an alphanumeric cell.

Syntax

CURRENCY()

Example

CURRENCY()

Where the Regional Settings are set to "English (British)", returns the British pound symbol, £.

If the Regional settings are set to "English (United States)", the function will return the symbol $.

Related Topics