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

L

Les P.

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.
 
R

Ron Coderre

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
 
Top