title: Best Practice - Format Multiple Currencies
body: <p>What is best practice for the scenario listed below?</p>
  
  <p>We have an application which we would like to support multiple currencies. The software will respect the users locale and regional settings to dictate the correct number format, i.e. $10,000.00 or 10.000,00₴ etc.</p>
  
  <p>We would however like to be able to format different numbers based upon a currency ID (perhaps the three letter ISO4217 code). Our idea is to store a table in the database with each currency and then request from the user to select the currency symbol which will be used. The program will then format all numbers based upon the locale/region setting but will use the currency symbol as defined in our program.</p>
  
  <p>So, given the following values and currencies<br>
  10000 AUD<br>
  5989.34 USD<br>
  450 EUR   </p>
  
  <p>the program would output<br>
  $10,000.00<br>
  $5,989.34<br>
  €450.00  </p>
  
  <p>or with a regional setting that formated numbers as #####,##$ the result would be;<br>
  10000,00$<br>
  5989,34$<br>
  450,00€  </p>
  
  <p>Respecting locale/region number formatting but displaying different currencies, what is best practice for this?</p>
  
  <p>I hope this makes sense.</p>
  
  <p>Technology used is c# .NET 2.0.</p>