Formulas Not Working

S

SteveW

Hi Guys,

When I enter a formula into a cell it does not do anything. Just the
text of the formula is left sitting there.

Do you know why this is and how I can fix it.

Thanks for your help,

Steve Wilson.
 
B

Bondi

SteveW said:
Hi Guys,

When I enter a formula into a cell it does not do anything. Just the
text of the formula is left sitting there.

Do you know why this is and how I can fix it.

Thanks for your help,

Steve Wilson.
Click to expand...

Hi Steve,

Maybe your cell is formated at Text when you enter your formula.
Try to delete your formula then RightClick -> Format Cells -> Number
and chose General
The re-enter your formula.

Also maybe you have check-marked Show Formulars under Tools -> Options
-> View -> Window Options... If so un-check it

Regards,
Bondi
 
N

Naz

I suggest you use another column, chances are the cell is formatted as text,
but changing it won't work.
 
S

SteveW

Hi Bondi,

How easy was that.

Thanks for your help and very quick reply, I appreciate it.

Best Regards,


Steve.
 
Top