View Single Post
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default Changing what is displayed in the formula bar

Select B10. Pull-down Edit Copy. Pull-down Edit Paste Special as value.
--
Gary''s Student


"Christina L." wrote:

Is there a way to change what is displayed in the formula bar.
E.g. Cell B10 contains a number. This number is the result of a formula.
The formula bar displays the formula. Can the formula bar display the number
that is contained in cell B10 and not the actual formula?

Thanks
--
Christina L.