title: Use variable in custom number format VBA
body: <p>I have a variable curr_code which stores the currency code taken from the spreadsheet/user as a string. It might take EUR/GBP/$ or whatever.</p>
  
  <p>And I have a custom number format I use to format the numbers in the spreadsheet as desired:</p>
  
  <pre><code>.NumberFormat = "#,##0.00" &amp; ";[COLOR 29]-#,##0.00" &amp; ""
  </code></pre>
  
  <p>How can I allow this Number Format to add curr_code at the end of the number which is formatted.</p>
  
  <p>ie, given curr_code = EUR, and the number was 670589.89474, it would be formatted as 670,589.89 EUR (including a space).</p>
  
  <p>All help greatly appreciated,
  Plastonick</p>