Sorting in excel 2000

D

datakop

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro using a cell reference 3
Sorting Revision Labels in Excel 1
Excel does not accept text format! 0
Excel Sorting 4
Sorting by rows with differing numbers of cell entries 3
Delete all data after a symbol in a field 0
Embed the same Excel multiple times 0
Excel Sorting Order 3

Top