| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
