Thanks G. student for your response. I will try that. Hopefully this works
with multiple cells - I will try and select several cells and give it a try.
Question - is there some sort of "set up" so this occurs as the default?
--
Christina L.


"Gary''s Student" wrote:

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.