Formula/worksheet error

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

I have a large spreadsheet that I am trying to modify a formula in. Whenever
I make any change to the formula, rather than returning the result in the
cell, it shows the actual formula. When I audit the formula it says that
"the cell currently being evaluated contains a constant". Have I hit a
limitation in the spreadsheet?
 
Format the cell to something other than text, then re-enter your formula
(select cell, F2, Enter)
 
Back
Top