software

Example:

The number in C10 is 12, as computed by a formula in the function bar (such
as =C8 C9). How do you delete the formula and RETAIN the number 11? Thanks.Look up 'Paste Special' in 'Help'
quot;Les P.quot; lt;Les gt; wrote in message
news
gt; Example:
gt;
gt; The number in C10 is 12, as computed by a formula in the function bar
gt; (such
gt; as =C8 C9). How do you delete the formula and RETAIN the number 11?
gt; Thanks.
gt;
Try this:

Select C10
Press the [F2] key
Press the [F9] key
Press [Enter]

That will quickly convert a formula to it value

Does that help?
***********
Regards,
Ron

XL2002, WinXPquot;Les P.quot; wrote:

gt; Example:
gt;
gt; The number in C10 is 12, as computed by a formula in the function bar (such
gt; as =C8 C9). How do you delete the formula and RETAIN the number 11? Thanks.
gt;


thks Ron!

ofcourse..I learned a new tip..!!

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=541752