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.

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.

When I paste a large amount of data into Excel containing dates as far back as the 1800s, the recent dates display correctly as valid dates, but the older dates automatically convert to text. ... You ...

Below is a screenshot of a snippet of the dates we will be converting in our Excel spreadsheet. If each date is in one cell, as they are in the spreadsheet above, they will need to be dissected first.