Converting cells with the VALUE function

Please purchase the course before starting the lesson.

When you want to convert cell values that are appearing as text to be valid numbers in Excel the first thing to try is the VALUE function in Excel. As per the help files, the VALUE function ‘converts a text string that represents a number to a number’. This will not work everytime though so you need to know more…

Back to: Data cleanup in Excel > Convert 'Text' fields into usable numbers