Thread: Formula Display
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kimbanev Kimbanev is offline
external usenet poster
 
Posts: 2
Default Formula Display

It is unticked, but the formula still appears. Control and back apostrophe
(to the left of the 1 on the keyboard) does not work either. Thanks for
trying.
--
Kim


"Sam Wilson" wrote:

Go to tools/options and click on the "view" tab. Make sure that in window
options at the bottom "Formulas" is unticked.

"Kimbanev" wrote:

Sometimes a cell's formula displays on my worksheet instead of the
calculation. Why does this happen, and how can I fix it? I've tried
re-formatting the cell, but this does not fix the problem.