Transfer a dollar value without the formula

[Bay]

If I have a dollar value that is arrived at with a formula, how can I transfer that value only to another cell without the formula.
ie

A B
1 a $1,000.00
2 b $500.00
3 a+b $1,500.00 =sum(B1,B2)

5 c ________ need $1,500 in B5 as $1,500 without the formula.

Thanks, Peter

[TMS]

Manually, copy the cell and Paste Special | Values. Or, you could automate it with a macro.

[Bay]

Tnx! Quick, simple and it works.

[TMS]

You're welcome. Thanks for the rep.