How to Unify the Date Format in Microsoft Excel

Date:2019-9-10 Author:Cordelia

To record a set of data in Microsoft Excel, you probably don’t think much about the format at the beginning. The data like dates can be entered in Excel with different formats by yourself or several different people. But things change, now you want to rearrange the dates in the spreadsheet. At this point, how can you unify the date format in Excel?

To standard and unify the date format, you can make use of Text to Columns in Excel. It enables you to choose from several common options of date formats.

1. First, select all the cells containing dates.

How to Unify the Date Format in Microsoft Excel

2. Switch to Data tab and click Text to Columns.

How to Unify the Date Format in Microsoft Excel

3. Choose Delimited and hit Next.

How to Unify the Date Format in Microsoft Excel

4. Click Next directly without making any change to current settings in this step.

How to Unify the Date Format in Microsoft Excel

5. Select Date in Column data format and choose the date format you prefer in the drop-down list beside it. Then specify the Destination for the dates with standard format. Hit Finish to implement it. 

How to Unify the Date Format in Microsoft Excel

6. Now all the dates in selected cells are unified to the standard format you chose.

How to Unify the Date Format in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *