title: How to convert or change the different date formats into one in excel
body: <p>The dates field in my dataset is of 2 different formats. Even though I formatted the cells to be in dd/mm/yyyy for all the cells, is it still the same. </p>
  
  <p>The issue is because these dates are from different datasets. I merged them under one column. Any solution for this? </p>
  
  <p>attached image for reference.<a href="https://i.stack.imgur.com/HJOwP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HJOwP.png" alt="different date formats"></a></p>