Couldn't you just type in the number?
--

Regards,

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

"Gary''s Student" wrote in message
...
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.