View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
james james is offline
external usenet poster
 
Posts: 3
Default Why can't this table be sorted?

Could someone tell me why this table cannot be sorted on the energy factor
column? The sort function is greyed out.

http://downloads.energystar.gov/bi/q..._prod_list.xls

At first I thought because the "numbers" are text, so I created a new colum
K using =H1 and extended down, then I copy and paste the values into column
J.

Surprisingly, column J still won't sort.

Even if I manually enter some numbers into a new column, they still won't
sort. $&*%$*?