View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carey Carey is offline
external usenet poster
 
Posts: 3
Default Cell format problem

I am doing pivot table reports in Excel 2002, and the there are several
numbers that are not sorting in numerical order. Instead they appear at the
top of the list. I have tried changing the format or the cell, and also
clearing the contents. I have made the format in all cells the same, but it
still won't sort correctly. The pivot tables don't give me the info I need
unless they are in numerical order. Any suggestions?

Thanks...Craey