Excel - Pivot Table

Posted on 2011-02-11
Last Modified: 2012-06-27

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.
Question by:tahirih
LVL 33

Accepted Solution

jppinto earned 125 total points
ID: 34874753
Try to format the source field as number instead of text to see if it helps.


Assisted Solution

hitsdoshi1 earned 125 total points
ID: 34874993
If its a text field then number is 01 instead of 1.

Author Comment

ID: 34875031
I tried the reformattingint to number - it did not work.

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 42

Assisted Solution

dlmille earned 125 total points
ID: 34881566
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.

LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 125 total points
ID: 34886957
Or just drag and drop the items into the order you want manually.

Author Closing Comment

ID: 34890198
Thank you.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Everything left of comma in excel 4 44
Excel 2013 Issues 11 44
EXCEL formula that pulls formatting as well 12 44
Excel Macro 9 18
Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question