Formatting Currencies With LocCurrL$() or LocCurr$()

 

The "LocCurrL$()" function returns a string with the currency format and symbol that is valid for the country. Insert the number value to be formatted as a parameter. The (optional) second parameter is the ISO 3166-Country code for the country whose currency format is to be used.

 

Example:

LocCurrL$ (1000)          Result: "$1,000.00 "

The "LocCurr$()" function returns a string with the currency format that is valid for the country but without the currency symbol.

 

Example:

LocCurr$ (1000)                     Result: "1,000.00"

You will find more information about this function under Overview of Functions.