How delete formula bar and retain the computed number in a cell?
 

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.

How delete formula bar and retain the computed number in a cell?
 

Look up 'Paste Special' in 'Help'
"Les P." <Les wrote in message
...
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.

How delete formula bar and retain the computed number in a cell?
 

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, WinXP


"Les P." wrote:

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.

How delete formula bar and retain the computed number in a cell?
 

thks Ron!

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

-via135


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