Hi Peter,
Since those are probably constants, that actually
would simplify that if that is all there is to it.

Format the output area as text, and copy the
input area, the paste as values (edit, paste special, values)

My Excel is 2000, just in case that doesn't work for you.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]


"peter" wrote in message oups.com...
OK, that worked for my example. In my actual spreadsheet, I am copying
data from one sheet to the next where I sort it. I wasn't able to get
it to work when I copied and pasted data. Do I format the original
sheet as text and the sheet on which it is sorted? Maybe I didn't try
hard enough, but I'm wondering if you have a quick answer.