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.

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

To convert a serial number to a date format, follow the steps below. Select the cell you want to format. On the Home tab in the Number group, click the bottom right arrow.

For example, "2012" entered into a date-formatted cell becomes July 5, 1909 in Excel for the Mac and July 4, 1905, under Windows. That's because the Excel for the Mac treats January 2, 1904, as ...

Follow the steps below to convert text to columns in Excel: Launch Excel. Enter some data into a single cell, for example, the first name and last name of people.

The IF function is one of the most flexible functions in Microsoft Excel and has a range of uses that can be helpful in comparing data entries and isolating specific data points. The IF function can ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

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

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.