Why is my cell displaying the formula ?
I tried formatting the cells as general before and after I entered the
formula but I kept seeing the formula in the cell not the result. I eventually added a new sheet and it worked ok.But I still wanted to know what happened |
Why is my cell displaying the formula ?
Hi,
Try this. Hold down the Ctrl key and tap ` which is to the left of the 1 key and you should see your formulas. Do it again and you'll get your formula results back. The other way is Tools|Options|View tab and check/un-check formulas. Is that what you saw? Mike "STARR" wrote: I tried formatting the cells as general before and after I entered the formula but I kept seeing the formula in the cell not the result. I eventually added a new sheet and it worked ok.But I still wanted to know what happened |
All times are GMT +1. The time now is 12:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com