title: How to convert date formats in excel (dd/mm/yyyy hh:mm:ss to mm/dd/yyyy hh:mm:ss)
body: <p>I have a autogenerated report that has some formatting on dates I need updated from dd/mm/yyyy hh:mm:ss to MM/DD/YYYY HH:MM:SS am/pm. Sometimes the data also does not have the seconds and it I do need the data to read at least 00 on the seconds. I am unsure if VBA or a enhanced formula is needed here due to the variance of times generated with and w/o SS.</p>
  <p>I tried =TEXT(F2,&quot;DD/MM/yyyy hh:mm:ss&quot;); however it did not work on the las to entries, it kept it as 15/11/2020 10:20 PM</p>
  <p><a href="https://i.stack.imgur.com/2BEbb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2BEbb.png" alt="enter image description here" /></a></p>