Totals only (formulas deleted)

[billy2willy]

Hi, I am just wondering how you can save your totals and delete your other information that was used to make your total and at the same time delete your formula that was used to make your total. For example if in column A you have your list of numbers and cell A10 your total - lets say 100. How would you then be able to keep that total and delete the formula that was used previously to get your total SUM(A1:A9) and also the formula in A10 to show just the total 100 without manually putting 100 in cell A10?

Hope that's clear.

[swatsp0p]

Select the cell you want to remove the formula from, click Copy then Paste Special>Values

HTH

Bruce

[Ron Coderre]

Two ways...

For the odd cell:
Select the cell. Press [F2] then [F9] (edit, calc), then [Enter]

For a range of cells:
Select the range then Edit>Copy followed by Edit>PasteSpecial>Values.

Does that do it for you?

Regards,
Ron

[billy2willy]

Thanks guys that does the trick....