1) add your new column with the sum in it
2) copy it
3) edit paste special values
4) now the values are fixed you can delete the detail and move on


--
Allllen


"Kate Bissell" wrote:

I want to create a summary report from a one year detail report. I have 12
months of data, but I want to total it, sort by the totaled number and get
rid of the detail data. How can I make my sums, or move my column of sums
into a column of absolute number so I can delete the detail, sort by the
remaining totals, to clean up the report?