title: Inconsistent behavior of conversion to/from locales
body: <p>I'm noticing strange and anoying behavior in excel probably due to the different number notation in Belgium.
  When I type this in the immediate window, I get counter-intuitive results:</p>
  
  <pre><code> ?val("0,5")
   0
   ?val("0.5")
   0,5
  </code></pre>
  
  <p>so my workaround is to use it like this (normally the string <em>"0,5"</em> is replaced by <em>textbox.value</em>)</p>
  
  <pre><code> val(replace("0,5",",","."))
  </code></pre>
  
  <p>Also when using the numberformat() function this get me into this kind of troubles.</p>
  
  <p>At first I had a the KeyPresses in the textbox limited like this:</p>
  
  <pre><code>Select Case KeyAscii
    Case vbKey0 To vbKey9, vbKeyBack, vbKeyClear, vbKeyDelete, vbKeyLeft, _
    vbKeyRight, vbKeyUp, vbKeyDown, vbKeyTab, vbDecimal
    Case Else
      KeyAscii = 0
      Beep
    End Select
  </code></pre>
  
  <p>But the vbDecimal would only allow me to enter '.'  as a decimal point and then at runtime it would be interpreted as times 1000 the value.</p>
  
  <p>Any light on this ?</p>