Cell format problem

C

Carey

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
 
L

Luke M

Can you change the sort order to "ascending"?

Its found under format field (not cell)
 
C

Carey

No, somehow it still sorts about 5 numbers before all the others. It's
thinking these numbers are different somehow from the others. I've tried
deleting and clearing and re-entering the numbers, but it still always sorts
with 5 on top of the list.

Thanks...Carey
 

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

Removing blank cells 13
Tying to extract all data from a pivot pulling from external data 3
Pivot Table Change to US Date Format - Why? 2
Numerical Sorting 1
Conditional Format text Excel 2003 2
Sorting in Numerical Order 4
Text sort in pivot table 2
Pivot table drill down data 2

Top