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.

To get rid of the problem, all you have to do is convert dates stored as text into dates. Launch Microsoft Excel 2010 and open the spreadsheet you want to edit.

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.

Converting empty cells means that they will be formatted as text if you enter data into them in the future. Navigate to the "Number" group within the "Home" tab in Excel. Click the small arrow ...