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" wrote:

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

On Sun, 13 Jul 2008 08:36:01 -0700, Mahmood
wrote:

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.