Arturo

Easiest would be to have another column with the numbers 1 - 500

Sort on that column to get original order back.


Gord Dibben Excel MVP

On Wed, 2 Mar 2005 09:03:03 -0800, Arturo
wrote:

I have a range of unique identifiers A1 through A500.
I sort on a different column then need to resort on those unique identifiers.
How do I prevent
a1
a10
a100
a101
a102
a103
a104
a105
a106
a107
a108
a109

When it should be
a1
a2
a3
a4
a5
a6
a7
a8
a9


Thanks,
Arturo