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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a function 1
Time formulas 15
I need to divide multiple cells by a single control cell in order. 2
How do i find last not empty cell in a range 9
Timesheet in and out rounding 3
Payment calculation 1
Summing a range of cells based on criteria in another range 2
Insert Row - Stop Automatic Formula Update 1

Back
Top