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…
Converting cells with the VALUE function
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.