Normally I would just use the "c" format to show currency values; however, in this app one record could be in US Dollars, the next in Brittish Sterling, the next in Mexico Dollars, etc...
I could leave off the $ amount in the format and just use #,###.00 which didn't work for me
or
Is there an easy way to format each row for a specific currency?
Here's a little sample I whipped up to do this kind of thing.