Just so you realize that you are *removing* all your formulas so that there
can *no longer* be any more calculations performed!

If you will need further calculations, make a copy and work on the copy.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Christina L." wrote in message
...
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.