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

[Guest]

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?

 

[L. Howard Kittle]

Copy > Paste Special > Values

HTH
Regards,
Howard

 

[Paul B]

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

 

[Guest]

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

 

[L. Howard Kittle]

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

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

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?

 

[Guest]

Regarding: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

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

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

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?