check if the cell is formated as text
check to see if <tools<options<view has formulas checked.

if it is still showing the formula
select the equals sign and replace it.
If noe of thes work, I don't know

"smithers2002" wrote:

My formula calculation appears in the cell rather than the result/value- why
is this happening, and how can I stop this?

Thanks