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

B

buffalo1

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?
 
P

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
 
R

Ron Coderre

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

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

Ron Coderre said:
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 said:
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?
Click to expand...
Click to expand...
 
R

Ron Coderre

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


L. Howard Kittle said:
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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Top