Buzz
Following our previous article which demonstrated converting numbers to text in Excel, receiving positive feedback, today Mytour shares another simple trick: how to convert numbers to dates in Excel, which is quite straightforward. Simply follow the steps below.
Step 1: Select the entire column of numerical data you want to convert to dates, then go to Data -> Text to Columns.
Step 2: The program will prompt you to perform the following 3 steps:
- Set the delimiter to the special character and click Next
- Keep Tab as default and click Next
- Choose the YMD format (YEAR/MONTH/DAY) to convert the result into the format dd/mm/yyyy established in the system.
In this step, besides choosing the YMD type, you need to select the destination position to export the result (or overwrite the original data) in the Destination to Finish section.
And here is the result you'll get.
Above is the guide on how to convert numbers to dates in Excel. Additionally, Excel also allows you to convert text format to dates. For details on how to convert text to dates in Excel, you can refer to the article on Mytour.
The trick above is only applicable if your Excel file encounters no issues or errors with dates. If the date format is incorrect, you can refer to the article on fixing date errors in Excel here.
Removing date formatting in Excel is a common query we've received from many of our readers. Therefore, we've also written an article sharing how to remove date formatting in Excel. Readers can refer to and apply it when encountering specific cases. Wish you success!
