title: CSV converting date from US to UK format only changes some, not all
body: <p>I have a CSV file that contains a few date columns. It was created with the US format of dd/mm/yyyy. I need to switch those dates to the UK dd/mm/yyyy. Saving the file seems well and good. But when I reopen the file many of the dates appear without the zeros if they had one as the first digit. An example:</p>
  
  <p>saved as - 03/03/2012
  when re-opened - 3/3/2012</p>
  
  <p>I'm using Excel 2007 and saved from xlsx to all possible CSV options (mac, windows, ms-dos..)</p>
  
  <p>Anyone know why this is happening, or more importantly a solution?</p>