How to Change 5 Digit General Numbers to Date Format in Excel

It sometimes happens that we type or copy/paste date formats from sheets in Excel, but it displays as number. Let’s convert those 5-digits general numbers to date format with 2 easy steps using default date formatting function.

For example, we copied date from external source or wrote date in the cell but it displays in 5 digit number format as shown in the below screenshot:

Follow 2 easy steps to change 5 digit number format to date format.

Select the 5 digits numbers and click Number format box in Home Tab. Now select Short Date as shown below:

All selected 5 digits numbers converted to dates with default date formatting as shown below:

If you have any queries or suggestions, feel free to comment below. I will be happy to reply you.