title: Remove dot in string, issue with numbers < 1000
body: <p>I have a column with data taken from CSV file, the data contain the dot I need to remove. When I want to replace „.“(dot) with „“ (nothing) with VBA I have a wrong result. All numbers smaller than 1000 replace the comma, I have for example 122,49 and the result is 12249 which is wrong. 
  I tried several VBA codes, non of them worked. 
  If you can help me it would be great. I tried all options with formats.. </p>
  
  <p>Thank you.</p>
  
  <ul>
  <li>2.078,00 -> 2078,00 ok</li>
  <li>122,49 -> 12249 ko</li>
  <li>328,28 -> 32828 ko</li>
  <li>11.192,34 -> 11192,34 ok</li>
  </ul>
  
  <blockquote>
  <pre><code>Sub TEST() 
      Dim i As String
      Dim k As String
      i = "."
      k = ""
      Columns("P:P").Replace what:=i, replacement:=k, lookat:=xlPart, MatchCase:=False
  End Sub
  </code></pre>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/0p1Y8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0p1Y8.png" alt="wrong result"></a></p>