formula viewing format
 

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

formula viewing format
 

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

formula viewing format
 

TOOLS
OPTIONS
VIEW Tab
Uncheck "Formulas"

HTH,
Elkar


"Roger" wrote:

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

formula viewing format
 

Roger

Could be either or both of two reasons.

1 The cell is formatted as text. Format as General then F2 and <ENTER

2. You are in "Formula View". Hit CTRL + ` (backquote above Tab key) to toggle
on/off.


Gord Dibben MS Excel MVP

On Fri, 5 Jan 2007 12:40:01 -0800, Roger
wrote:

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