Convert Text to Numbers in Excel - Spreadsheets - About.com How to convert text data to numbers in Excel using the VALUE function. ... the complete function = VALUE ( D1 ) appears in the formula bar above the worksheet.