Buzz
In this tutorial, Mytour will guide you on how to use Flash Fill to convert numerical values into date format in Excel. As you can see in the example below, the spreadsheet has 2 columns, one containing numerical values and the other we will convert the numerical values into date format in Excel easily.
How to use Flash Fill to convert numerical values into date format in Excel
Step 1: Enter 04-23-2016 into the first cell in the Date Format column.
Step 2: Since we want to apply the same format throughout the rest of the spreadsheet, in the second cell of the Date Format column, input 12-30-2015.
Note that while Excel doesn't automatically suggest Flash Fill, it still occurs in some cases.
Because Flash Fill doesn't open automatically when you want to convert numerical values into date format in Excel, you'll need to do it manually. First, highlight the entire column you want to fill.
Then click on Data =>Flash Fill. Alternatively, press Ctrl + E.
Step 3: Now, the numerical values in the spreadsheet will be converted to date format.
With Excel, you can apply the same formatting pattern to the remaining sections of the spreadsheet without using individual formulas for each section.
Thus, Mytour has just introduced and guided you on how to use Flash Fill to convert numerical values to date format in Excel.
In addition to the Flash Fill function, you can explore Excel date functions for a better understanding. This provides a broader view of formulas in Excel, including mentioning some date functions like TODAY, DAY, etc. Try applying them and share your feedback with Mytour!
