Hi,

I want to sort rows of cells that are the result of calculations. I select
all the data I want to sort and identify the colums etc, but the sort does
not want to work on these calculated cells.

Is there a way to make excel just recognise the numbers in the cells, for
example the result of the If function are numbers, actually TV channel
numbers(202 etc.). I just want to sort the channel numbers in ascending
sequence along with the channel names.

I hope I have explained my problem correctly.

Thanks

Duncan