How to Convert Dates Stored as Text Into Dates. Working with large Excel files is sometimes a daily task when you run a small business.

Luckily, Excel offers handy formulas that allow you to convert text into upper case, lower case, title case, and even sentence case with minimal effort.

To ignore all numbers stored as text, you need to open the Data tab and select the Text to Columns option. Then, select the Delimited option from the Convert Text to Columns wizard.

Microsoft Excel has a feature that allows you to convert a number into a date, which is quite simple to do. This tutorial explains the steps to convert a number into a date format in Excel.

In Microsoft Excel, you don’t need an expression to calculate someone’s age – use Power Query to simplify the process.