title: Excel using date/time with multiple different region formats. VB? Formulas?
body: <p>I'm currently in US EST and the date format used within my company is </p>
  
  <blockquote>
    <p>Month/Day/Year Hour:Minutes:sec</p>
  </blockquote>
  
  <p>I need to copy and paste dates/time extracted from other regions and they have mixed formats. Some are the same as the format I have, while others are using the UK format </p>
  
  <blockquote>
    <p>Day/Month/Year Hour:Min:sec</p>
  </blockquote>
  
  <p>Currently, I have to manually edit the UK format to match with the rest so that my date formulas will be not have errors. This is starting to be a problem since I am facing more than 200 records, and each record has different time.</p>
  
  <p>Is there a code or formula I can use to solve this issue ? I understand that the datetime format can be solved with System region settings, but this does not help since, changing to either formats will still require me to manually edit those not affected..</p>
  
  <p>I'm thinking of using Visual Basic to iterate through, using each row's unique ID to identify if it is UK or US. Am I on the right track ? </p>
  
  <p>Otherwise is there an excel formula or method available for this?</p>
  
  <p>Thanks in advance</p>