Formula not converting

H

Hammer1235

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.
 
B

Bob Phillips

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

Or maybe you have formula view unset. Tools>Options>View check Formulas.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
K

Kevin Vaughn

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.
 
Top