View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan
 
Posts: n/a
Default 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.