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.
|