There are times when you receive a set of records in a worksheet and they are presented in text format. As such you are unable to use these text formatted numbers to perform calculations. In this case, you would need to convert them into numbers.

How then can we convert the text formatted numbers into real numbers that can be used for calculations?

Here is a function that will achieve what you are looking for. It is called the value function. Assuming that you have a text formatted number in A1. To convert it to a number, you just have to type in the formula say in A2 “=value(A1)”. The text formatted number would be converted to value and ready for you to perform calculations.