title: excel vba string to date
body: <p>Windows 10 Pro, Regional Settings to UK English.
  In Excel VBA I have a string "02/05/2017 16:30"
  That, in the UK, means "02 May 2017 16:30"</p>
  
  <p>But VBA turns this to US format somehow and in the cell puts "05/02/2017 16:30"</p>
  
  <p>The VBA code is like this</p>
  
  <pre><code>Dim sField As String
  sField = "02/05/2017 16:30"
  ws.Cells(1,1) = sField
  </code></pre>
  
  <p>I can use CDate to get around this but CDate but that requires extra code to determine which cells are dates and which aren't, whereas the implicit conversion works for all types.</p>