Problem:

Column B displays the text of the entered formulas, rather than their results.

Solution:

Column B was probably formatted as text prior to the formulas being entered.
In order for the formulas to return their correct results do the following:
1. Select all the formulas.
2. Set the format of their cells to \"General\" or \"Number\".
3. Select the formulas again.
4. Press
5. Press