Peter,

Select the cells that you want to sort, right-click and choose "Copy", then
right-click the same selected cells and choose "Paste Special..." -
click the button next to "Values" then press OK.

Then - do your sort.

HTH,
Bernie
MS Excel MVP

Didn't work for some reason. What option was I supposed to use for
paste special?