title: Excel: Convert US date format to European format
body: <p>I have the following US date format <code>5/30/2018 8:00:00 AM</code>. I am looking for an optimized formula to convert it into European format <code>30/05/2018</code> (dd/mm/yyyy) without the time. I have searched the net for a good solution, was not able to find an easy one. I am looking for a formula and not to format cells etc</p>
  
  <p>Moreover my computer is set for European format, which reads months and days wrongly. Any changes in excel to overcome this situation would be helpful.</p>
  
  <p>This question is not for VBA but i am requesting a formula to be entered in a cell. Also the source cell is not formatted as a number/date... its just a general cell or custom cell</p>