title: Changing decimal separator in VBA (not only in Excel)
body: <p>Type in A1 cell <code>=1/10</code> </p>
  
  <p>Run this macro:</p>
  
  <pre><code>Sub ChangeDecimalSeparator()
      Application.DecimalSeparator = "#"
      Application.UseSystemSeparators = False
      MsgBox Range("A1").Value
  End Sub
  </code></pre>
  
  <p>Apparently now in cell A1 you can see that the decimal separator has been changed to new character #. Why on earth VBA still sees it as your default seperator, although you have changed it (I mean the MsgBox).</p>
  
  <p>Why I need it? My default separator is , (comma). I want to insert data to SQL which used . (dot). </p>