The cells you are entering the formulas into sound as if they are formatted
as text, change the format to 'General'
Regards,
Alan.
"Roger" wrote in message
...
I know this is an easy one, I just can't find where to change it:

I working on a worksheet created by someone else and whenever I create a
formula in a cell the actual formula shows and not the result, where do I
change this?

thanks