Excel formula shows as text.

[WERNER SLABBERT]

Why is it that sometimes when i enter data into a completly empty cell it shows the enterder formula as normal text ( i ask this after i have set the cel format to general ) i can set it to whatever format i want it still shows just as text ????

anybody !???

 

[Steeviee]

Have you checked
Tools\Options\View and make sure that you don't have 'formulas' ticked?

 

[WERNER SLABBERT]

running 2007 and no the view is set to normal

 

[RoryA]

If you change the format to General after you entered the formula (and the format was originally Text) then you need to re-enter the formula after changing the format.