When I do an @sum, is there anyway to make the sum a constant ?
 

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?

When I do an @sum, is there anyway to make the sum a constant ?
 

Copy Paste Special Values

HTH
Regards,
Howard

"buffalo1" wrote in message
...
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?

When I do an @sum, is there anyway to make the sum a constant ?
 

buffalo 1, maybe copy, paste special, valves
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"buffalo1" wrote in message
...
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?

When I do an @sum, is there anyway to make the sum a constant ?
 

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?

When I do an @sum, is there anyway to make the sum a constant ?
 

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?

When I do an @sum, is there anyway to make the sum a constant
 

Regarding:
Is that the short cut key for copy, paste special, values?
Nah....but it emulates those actions in a single cell

[F2].....puts the active cell in edit mode
[F9]....converts the cell formula to its evaluated value
[Enter]..commits that value and exits edit mode

***********
Regards,
Ron

XL2002, WinXP


"L. Howard Kittle" wrote:

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?