I exported a peachtree report to excel. In one colum I did a SUM
calculation for the column 2 columns away (ie. in cell J34 I have a
Formula =SUM(H3:H34) where they are a column of numbers). The forumula
only shows in J34, not the value that should result from the
calculation. I have never run into this before. What's going on? I
do this all the time.

Hmmm... if I type the formula in, I get the answer. If I use the E
function to do it, I get only the forumla. Still would like to know
what the deal is.

I am using Excel 2002.

Thanks