Formulas in Excell 2007 nor working

[Mahmood]

When I try to use any function like =SUM(C154:C163), =COUNTIF(D2137,"a")
etc instead of giving the result it simply shown the formula as above in the
cell.

 

[daddylonglegs]

This means the cell is text formatted. One way round this...

Select column and use Data > Text to columns > Finish

 

[Gord Dibben]

I don't use 2007 but in earlier versions this could mean you are in "Formula
View" or the cells were pre-formatted as Text.

If the latter, Re-format to General then on each cell, F2 and ENTER.


Gord Dibben MS Excel MVP

 

[Mahmood]

I tried to change the format of the cells but did not work. But going to
blank cell and changing their format to general before inserting formula
worked. Thanks.

 

[Gord Dibben]

Did you read all of my post?

I said you must re-enter the formulas after re-formatting.

That's what F2>ENTER does.

Saves you re-typing the formulas.


Gord Dibben MS Excel MVP