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. If a space between the number and the currency symbol is appropriate for the locale, it will be added.

This means that an xlPrecision formula that returns "1.23" will return:

Of course, 1.23 US dollars is not the same amount of money as 1,23 Euros. However, this is how Microsoft Excel does it. By duplicating the way Microsoft Excel handles currency internationalization, xlPrecision allows you to internationalize currency in the same way you always have with Microsoft Excel.



xlPrecision Home Page
PrecisionCalc Home Page