Share via

Excel Pivot Table not sorting by number value correctly.

Anonymous
2021-04-01T02:59:54+00:00

Hi.

I cannot get this to sort in numerical order.  I tried A to Z & Z to A.  Both scenarios put the #1 in the incorrect order.  Can you please help me learn how to correct this? 

Thank You!

See two pictures below.  

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2021-04-01T03:22:35+00:00

    Re:  incorrect sort in Pivot Table

    Excel, when sorting, treats text and numbers separately.
    All text is sorted (grouped) together and numbers are done the same.

    From your image, it appears that "1" is treated as text.
    You can change "text" numbers back to numbers with
    the usual solution of making sure the number format is correct (number) and

    then multiplying the text number by 1 using Paste Special...

      Image

    '---
    NLtL https://1drv.ms/u/s!Au8Lyt79SOuhiXoNjAh-_-zLi49O Free:  Custom_Functions, Professional_Compare and more

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest