I enter in a formula on the worksheet, ex. =sum(2+2), hit the enter key and
in the cell I typed the column remains the formula =sum(2+2) it does not give
me the calculation of 4. I have tried to 'clear contents' in the event there
is something else there. I have deleted the column and added a new and it
continues to do this.

Apparently, your column (even your new column) is formatted as text. Try
formatting as General and re-entering (if it is just one cell, try F2 then
press Enter.) BTW, I know you are just using that formula for illustration,
but you wouldn't need sum in that instance. just =2+2 would work.
--
Kevin Vaughn


"Hammer1235" wrote:

I enter in a formula on the worksheet, ex. =sum(2+2), hit the enter key and
in the cell I typed the column remains the formula =sum(2+2) it does not give
me the calculation of 4. I have tried to 'clear contents' in the event there
is something else there. I have deleted the column and added a new and it
continues to do this.

Sounds like the sheet is formatted as text. Format it as General, and edit
the formulas.

Or maybe you have formula view unset. ToolsOptionsView check Formulas.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Hammer1235" wrote in message
...
I enter in a formula on the worksheet, ex. =sum(2+2), hit the enter key
and
in the cell I typed the column remains the formula =sum(2+2) it does not
give
me the calculation of 4. I have tried to 'clear contents' in the event
there
is something else there. I have deleted the column and added a new and it
continues to do this.