title: Macro find and replace to change string to date
body: <p>I used the macro to find and replacement function to change the string to date. It worked well with some of the dates but went wrong also. 
  The code I used is:</p>
  
  <pre><code>Worksheets(“Sheet 1”).Columns(“H”).Replace What:=“.”,
  Replacement:=“/“,
  SearchOrder:=xlByColumns,
  MatchCase:=True
  </code></pre>
  
  <p>The original string is <code>"11.01.2019"</code> and the date should be <code>11/01/2019</code> which is <code>11 January 2019</code>.</p>
  
  <p>But when I used the macro, it was converted to <code>01/11/2019</code>, which is <strong>1 November 2019</strong>. </p>
  
  <p>The code worked well if the day is bigger than 12.</p>
  
  <p>For example <code>"13.01.2019"</code> will be converted to <code>13/01/2019</code> correctly.</p>
  
  <p>Anyone can help with the code to make it work properly?</p>
  
  <p>Many thanks.</p>