xl Precision
Get Your Numbers Right

Internationalized Currency Formatting

On editions that offer internationalized currency formatting, setting the format_currency argument to TRUE adds the local currency symbol to the calculation result. The currency symbol will be added either to the beginning or to the end of the result, whichever is appropriate for the locale.

This means that an xlPrecision formula that returns "$1.23" in the USA will return:

• "1,23 €" in Germany
• "1.23 kr" in Estonia
• "1,23Lek" in Albania