Excel - Pivot Table

Hi,

In creating a Pivot Table in Excel 2007 - I have a field that is numbered MC 1 -  MC15. However, when displayed in the pivot table, the ordering is 1, 10, 15, 2, 3.

Please advise.

Thank you.
tahirihAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
Try to format the source field as number instead of text to see if it helps.

jppinto
0
 
hitsdoshi1Connect With a Mentor Commented:
If its a text field then number is 01 instead of 1.
0
 
tahirihAuthor Commented:
I tried the reformattingint to number - it did not work.

Thanks.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
dlmilleConnect With a Mentor Commented:
if the data is MC1, MC2, MC3.... to MC10 etc, then you need to change the source data to:

MC01, MC02, etc..

If you don't want to do that, create another field in your DATA, make it numeric and tied to the MC data field, and then sort the MC data by that numeric data field.

Dave
0
 
Rory ArchibaldConnect With a Mentor Commented:
Or just drag and drop the items into the order you want manually.
0
 
tahirihAuthor Commented:
Thank you.
0
All Courses

From novice to tech pro — start learning today.