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.

Click "Text" to convert your cells to text formatting. Advertisement. ... By default, Microsoft Excel 2003 displays long... References. Microsoft Office: Change the Column Width and Row Height; ...

text from one or more cells into one cell—date cells with text cells in an Excel formula, you must first convert the referenced date cells to text; otherwise, you end up with an unexpected result.

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