title: Excel VBA code for replacing all "." by "," in a column
body: <p>I would like to have an excel VBA macro in order to replace all "." (dot) by "," (comma) in a column in one sheet.</p>
  
  <p>When I try to do it with the following code, it replaces only if the cell value is ".". But does not replace "." inside cell value (i.e : 1.16 should be turned to 1,16 in column D inside sheet5)</p>
  
  <pre><code>Sub ReplaceDoTwComma()
  
  Worksheets("Sheet5").Columns("D").Replace _
  What:=".", Replacement:=",", _
  SearchOrder:=xlByColumns, MatchCase:=True
  
  End Sub
  </code></pre>
  
  <p>Can someone give me the good code to do this?</p>
  
  <p>Thanks in advance...</p>