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.