Step 2: Convert the Text to Date. To convert text to a date in Excel, you can use the ‘Datevalue’ function. This function converts a da. First, create a new column next to the column of data to be ...

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.

Type the formula =Value() and inside the parentheses, type a cell reference that contains text stored as numbers. In this example, it’s cell A2 . Press Enter.

Of course, not every calculation has a pre-built function in Excel. For instance, Excel functions can convert text to upper and lower case, but there's no Excel function for converting text to ...