Format the columns 30 - 60 - 90 -120

J

JoeM

Wouldn't ya know after I built all of this the stupid columns are coming out
as: >120, 120, 30, 60, 90
I need for them to look this way: 30, 60, 90, 120,>120

I know i've seen a post around here about this but I just couldn't find it
again.

Joe

PS anybody seen a good course online for advanced pivot table training. I
already did the Microsoft one.

Joe
 
G

Glenn

Just turn off Auto-Sort for that field and then drag them to the order you want
them.
 
G

Glenn

I gathered that much. Did you try what I suggested?

In case you weren't sure how, right click on one of the column headers, select
"Field Settings", click on "Advanced..." and under Auto-Sort Options select
"Manual (you can drag items to rearrange them)". Click "OK" and "OK". Then
drag the columns into the order you want them.
 

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

vlookup in aging 1
ageing analyses in excel 30-60, 60-90, 90-120 2
How to add 30, 60 and 90 days to date and calculate deepening disc 5
30/60/90/120 Aging 1
Formula For Summarizing Data 18
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Can't get this to work 3
Aging 30 60 90 2

Top