View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
al al is offline
external usenet poster
 
Posts: 363
Default Excel won't resolve formula in one column

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.