title: VBA Text-To-Columns Reading Date Format As US
body: <p>When running text-to-columns in vba, it puls my dates as american dates, instead of uk dates, as long as it is possible for it to do so. So for example, 31-Aug stays as 31-Aug, but 01-Sep changes to 09-Jan!</p>
  
  <p>Is there any way to specify that all dates are in UK format BEFORE vba runs? As even just reformatting to US dates to show as US dates won't work because we have code that runs <code>if date &lt; Today</code>, which of course will cause issues with the changing date format.</p>
  
  <p>The data feeds in the format dd/mm/yyyy, but excel reads it as mm/dd/yyyy!</p>