Missed out one step ..

In the new sheet, after copypasting special as values/formats, we've got to
delete all the previously "blank" rows below the last row of data before
sorting. Just select the row headers for these, then right-click Delete.
Then do the sort as per normal.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----