The cell B1 must have been formatted as text before you typed your
formula in. Use Format | Cells | Number (tab) and select General and
OK. Then double-click in B1 as if to edit the cell then press <enter.
You should now see the result, and you can copy B1 down the other cells
in column B.

Hope this helps.

Pete