title: Powershell: Importing date into Excel changes format
body: <p>I've been using the following code to add a date into excel</p>
  
  <pre><code>$worksheet.Cells.Item($current_Row,3) = ([datetime]$entry.Completed_Date).ToString("dd/MM/yyyy")
  </code></pre>
  
  <p>However when I check in excel, the format is always "MM/dd/yyyy"</p>
  
  <p>Is there anyway to manipulate the string? Or change the cell format so that the date stays in "dd/MM/yyyy"</p>
  
  <p>Edit: My current solution is this
  I set the cells format using <code>.Numberformat = 'dd/MM/yyyy'</code> and then I need to format the date to be in MM/dd/yyyy. Excel will then flip around the MM and dd for me. It looks like excel is anticipating the date to be inputted in <code>MM/dd/yyyy</code> before changing it to <code>dd/MM/yyyy</code></p>