• Text Functions
  • ANSI Character Functions
  • CLNTDIR Function
  • CLNTNAME Function
  • CURRENCY Function
  • DOCPATH Function
  • IN Function
  • LEFT Function
  • LENGTH Function
  • LOWER Function
  • LTRIM Function
  • MID Function
  • MKSTR Function
  • PRGDIR Function
  • RIGHT Function
  • SCANSTR Function
  • SPACE Function
  • STR Function
  • SUBSTR Function
  • Text Functions
  • TITLE Function
  • TOKEN Function
  • TOKENSUB Function
  • TRIM Function
  • TRIMRTF Function
  • UPPER Function
  • XRND Function
  • XWKS Function

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

• Text Functions