Convert between US and European date formats in Excel

The easiest way I know of (please let me know if you know a better way) to convert between US ("mm/dd/yy") and European ("dd/mm/yy") dates without using VBA in Excel is via "Text to Columns". Let's look at an example: My system's regional settings are setup for US dates, therefore I need to convert the …