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.

Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

Excel doesn't offer a one-click solution if you need text in sentence case (where only the first letter of the sentence is capitalized). But don’t worry! You can create a custom formula using the LEFT ...

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 ...