title: Change to Canadian (CDN) French number formatting in Excel VBA
body: <p>I would like to build a piece of code which can convert numbers in my workbook from English to French number formatting. </p>
  
  <p>For example, </p>
  
  <ul>
  <li>English formatting would be <code>$1,000,000.99</code>, and </li>
  <li>French would be <code>1 000 000,99 $</code></li>
  </ul>
  
  <p>I can not seem to find any default French codes built into excel and using a <code>,</code> instead of a <code>.</code> for the decimal does not show numbers less than $1. </p>
  
  <p>Any assistance or advice is appreciated!</p>