Hummm,

Is that the short cut key for copy, paste special, values? Checked my
short-cut key strokes print out and don't see it.

Very clever... or a way big oversight on my part.

Thanks, Regards
Howard

"Ron Coderre" wrote in message
...
Try this:

Select the cell with the SUM
Press these keys in order: [F2] [F9] [Enter]
(that will convert the formula to its result)

Alternatively, you could
<edit<copy
<edit<paste special
Check: Values
Press the [Enter] key

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"buffalo1" wrote:

I have a SS that I need to sum dollars and then delete the rows with the
sum
numbers. Is there a way to make a formula a constant?