Formula displaying don't know why
I put a formula in a worksheet and instead of making the calculation the
formula is showing. I checked Tools/Options/View but Formulas is not checked off. Also Tools / Options / Calculation is set to automatic. Do you know why this is happening |
Formula displaying don't know why
Just figured it out. The cells I was having trouble with were locked. Thank
you. "Jazz" wrote: I put a formula in a worksheet and instead of making the calculation the formula is showing. I checked Tools/Options/View but Formulas is not checked off. Also Tools / Options / Calculation is set to automatic. Do you know why this is happening |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com