Hello, In this global world many businesses conduct their operations in different currencies. When they store the transaction they generally store the data as the transaction value in one field then...
Agree 100%. Formatting currency values based on the viewer's locale is a bizarre idea. This lack of multi-currency support is a real oversight. My proposed solution would be the same as Matt, that is to select a column in the same table which holds the three character currency code. I have also been down the FORMAT route, and as pointed out, the resulting string is then useless for summations and averages.
