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

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.