Excel Tip – Convert American date format to British date format and vice versa

To convert an American date in cell A1 i.e. 12/29/2015 to a British date i.e. 29/12/2015 select A1 and then go through the following steps:

American to British format

  • On the “Data” tab in the “Data Tools” group select “Text to Columns”
  • Select “Delimited” and click “Next”
  • Untick all the checkboxes and click “Next”
  • Select “Date: MDY” and click “Finish”

British to American format

To change a British date in A1 into an American date use the formula =TEXT(A1, “mm/dd/yyyy”).

Share this tip on