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