Posted on Leave a comment

Convert date to standard Excel format – easy solution

It’s not surprising that not everyone follows the instructions and enter dates in cells in standard Excel format. Also, it often happens when you export data from a database to xlsx file or import data from web to Excel that the format of dates differs from the standard one.

Some people struggle writing complicated formulas, but fortunately, Excel is equipped with Text to Columns tool. Text to Columns tool can convert any nonstandard date format to the standard one.

Let’s suppose that your task is to convert yyyy.dd.mm date format to standard Excel date format.

Here are the steps to follow

  1. Select cells.
  2. Go to Data tab and click Text to columns icon.
  3. In the first step of Convert Text to Columns Wizard choose Fixed width data type and click Next button.
  4. Don’t insert any break lines in the second step of the wizard. Just click the Next button to move on.
  5. In the third step of Convert Text to Columns Wizard select in the Column data format list Date.
  6. Drop down the list and select the date format that you need to convert. In this example, it is the last one YDM.
  7. Click Finish Button
  8. The dates have been converted to your Excel standard format.