title: VBA - replace characters in string
body: <p>I have 1 column, which should contain an amount, but it has incorrect formatting and it is treated as text.</p>
  
  <p><a href="https://i.stack.imgur.com/MrEZ0.png" rel="noreferrer"><img src="https://i.stack.imgur.com/MrEZ0.png" alt="enter image description here"></a></p>
  
  <p>Therefore, there is necessary to replace dot for nothing and then comma for dot. I have code:</p>
  
  <pre><code>Private Sub Correction_of_dot()
      Dim i As String
      Dim k As String
      i = "."
      k = ""
      Columns("P:P").Replace what:=i, replacement:=k, lookat:=xlPart, MatchCase:=False
  End Sub
  
  Private Sub Correction_of_comma()
      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>
  
  <p>But it does nothing... no errors, just loading and then nothing has happened. Could you advise me, what I've did wrong or what can I do better, please?</p>
  
  <p>Many thanks!</p>