ExcelBanter - Formula/worksheet error

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Formula/worksheet error (https://www.excelbanter.com/new-users-excel/261967-formula-worksheet-error.html)

Kim

Formula/worksheet error

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?

Luke M[_4_]

Formula/worksheet error

Format the cell to something other than text, then re-enter your formula
(select cell, F2, Enter)

--
Best Regards,

Luke M
"Kim" wrote in message
...
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?

All times are GMT +1. The time now is 07:08 AM.