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.