Excel is software that lets you create tables, and calculate and analyze data. This type of software is called spreadsheet software. In Excel, dates and times are stored internally as numbers. These are only converted to legible dates and times when you format the cell using a date or time format.
Step # 1 - Change dates that Excel can understand
Lets look at an example. Lets change dates like this one: 20030923 to one Excel can understand it.
Step # 2 - Go to the data tab
Select the date, and click on Data tab. Then choose Text to Columns.
Youll see the Text to Columns window. Even though the dates are fixed width, in this case you can simply click Next twice. In step 3 of the Wizard, select Date: YMD. If you click Finish, the result will replace the dates. You can also select another destination cell. Thats it!
Result: Congratulations! Youve just learned How to Make Excel Understand Dates Date: 2023-07-08
