Thanks for all your suggestions though can work on it now , will look at it
tomorrow but i shouldnt forget to Thanks , so writing response

"Jacob Skaria" wrote:

Check out the cell format.(it must be Text now) in which the formulas will
not work.

Change the formula cell format to General...If that doesn't work copy a
blank cell. Select the data fieldsRight click PasteSpecialAdd Click OK.
Now try summing...


If this post helps click Yes
---------------
Jacob Skaria


"Max" wrote:

After i extract my values from database and make it view through excel2007 and
when i do autosum on needed columns , it does not calculate but instead the
formula stays, y is it so
thanks
max