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.