I'll bet the "bad" cells started out formatted as text. If you change it to
"General" the "=5+2" will still remain. If you put your cursor at the end of
the "2" and hit return (after changing the formatting to General) i think it
will work as you wish.

Pete

"AL" wrote:

In one spreadsheet column, if I enter "=5+2" into a cell, it does not resolve
the formula. The value displayed is "=5+2" instead of "7". It treats every
entry as text. Other columns act normally. Cell format is the same between
bad column and good columns. It does not resolve formula no matter what the
cell format is (general, number, text, etc.). If I click on "evaluate
formula", the dialog says "The cell currently being evaluated contains a
constant.