what is this?

[pierre]

i am having a problem.
i try to enter a formula in cell c1 like :
=a1/a2
but when i press enter i get this: =a1/a2
what is wrong ??

 

[Mike H]

Hi,

2 Options

1. the cell was formatted as text
Format as general and while still in the cell tap f2 & Enter.

2. Tools|Options - view tab
Un-check 'Show formulas'.

Mike

 

[Gord Dibben]

The cell is formatted as Text or you have View Formulas enabled.

For the View Formulas hit CTRL + `(backquote above Tab key)

For the Text, re-format to General then F2 then ENTER to re-enter the
formula(s).


Gord Dibben MS Excel MVP