Force Excel to see the value (instead of text)

Please sign up for the course before starting the lesson.

The VALUE function is useful to try and force Excel to see a number as a number. Whenever Excel is not adding correctly or giving you a VALUE error, it is suggesting that something you see as a number, is not a valid Excel number.

As shown below, in B4 and B5 we have numbers that to a human would be valid. But Excel does not see them as numbers.

To see the full course contents click here.

Back to: Intermediate Excel Course > Text Functions