How to Batch Convert Number to Date Format in Excel

Date:2019-8-5 Author:Olivia

While working with Excel, if there are a large number of dates to enter, you can enter the numbers without the format at first for convenience, then batch convert them to the format of date. So how can we achieve it? Here’s a simple guide.

1. First, enter the numbers and select all of them.

How to Batch Convert Number to Date Format in Excel

2. Then, click Text to Columns in Data tab.

How to Batch Convert Number to Date Format in Excel

3. Next, Choose Fixed width and click Next.

How to Batch Convert Number to Date Format in Excel

How to Batch Convert Number to Date Format in Excel

4. After that, click Next again.

How to Batch Convert Number to Date Format in Excel

5. Finally, choose the date format in Date option and click Finish.

Note: The date format you choose must be corresponding to the order of the number you entered. Otherwise it cannot be converted correctly.

How to Batch Convert Number to Date Format in Excel

How to Batch Convert Number to Date Format in Excel

6. Now, the number is converted to the format of date.

How to Batch Convert Number to Date Format in 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 *