Good Morning All,

I was wondering if there was a way to get excel to sort complex numbers correctly.

When sorting numbers like this volume 4 should be after volume 3 but ends up coming after volume 39.

LNBV-97-1135 vol. 4
LNBV-97-1135 vol. 40

Anyone know a way to get excel to sort numbers like this? I have a sheet with over 60,000 entries on it like this and sorting it is becoming a real pain.

Thanks in advance for any help