I have an Excel spreadsheet that has been created by someone else. I have a number column (created from formula) which has both negative and positive numbers in that am trying to sort but nothing happens when i try. Could there be some lock on it? If so, what?
I have created a copy of the list as number only which will allow me to sort but it will not allow me to expand selection so that I can use it to sort the database.
Any ideas on how to get around this?