title: Why is VBA changing decimal to comma automatically?
body: <p>I have an Excel macro in VBA. Yesterday everything worked fine, this morning VBA is changing a decimal point to a comma. That is from 5.1 to 5,1.</p>
  <p>I am using a German system and have set in Excel's advanced options that a point is a decimal and comma is thousands.</p>
  <p>For example I have a value for daily scrum meeting in the Excel sheet set at 3.75</p>
  <p>Excel sheet input:<br />
  <a href="https://i.stack.imgur.com/9lRJ4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9lRJ4.png" alt="screenshot" /></a></p>
  <p>When I use a function to read in the value such as:</p>
  <pre><code>Sub TestFunction()
      MsgBox (Sheets(&quot;Input_Parameters&quot;).Cells(25, 2))
  End Sub
  </code></pre>
  <p>I get the value with commas.</p>
  <p>VBA function output:<br />
  <a href="https://i.stack.imgur.com/gvRAC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gvRAC.png" alt="output" /></a></p>
  <p>Is there a setting in the VBA environment to fix this or is there something I am missing. All my backups of the macros are showing the same affect so I know it is nothing I have changed in the code in today's version.</p>