title: Keeping a date format when converting to text in VBA
body: <p>I am struggling with handling dates within excel/VBA</p>
  
  <p>I have a spreadsheet with a date column, displaying in UK format as expected.</p>
  
  <p>I am then manipulating the spreadsheet and saving it as a text file in order to load the data into another system.</p>
  
  <p>My problem comes when I save the file as it does two things, first due to the US bias of Excel, it attempts to "flip" the dates so for example  1st July 2012 goes from 01/07/2012 to 07/01/2012</p>
  
  <p>Secondly when I then save the file and re-open the text file, it seems to have then dropped the zeros so my date now not only reads the wrong way round, but with no zeros so is showing 7/1/2012</p>
  
  <p>The system I am importing to is very specific about the format of the dates it accepts.</p>
  
  <p>I have tried all sorts</p>
  
  <pre><code>ActiveCell.FormulaR1C1 = "=TEXT(RC[-1],""dd/mm/yyyy"")"
  
  Cells(x, 3).Value = Left(CStr(Cells(x, 3).Value), 2) + "/" + Mid(CStr(Cells(x, 3).Value), 4, 2) + "/" + Right(CStr(Cells(x, 3).Value), 4)
  </code></pre>
  
  <p>Within Excel both of these do the trick in keeping the format I require, it is when I then save the file as text I get the problems above.</p>
  
  <p>I almost want to pad the date with zeros and force the save as a literal string, but I am running out of ideas.</p>
  
  <p>I am sure this is a simple fix, but I need some other eyes on the problem so any help is appreciated</p>