Formulas in Excell 2007 nor working

M

Mahmood

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

daddylonglegs

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

Select column and use Data > Text to columns > Finish
 
G

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
 
M

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.
 
G

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
 
Top