Two ways for sorting by Number


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Choosing the sort type is really important and Word doesn’t always guess correctly.

Office-Watch.com reader Peter M. reminds us that choose the sort type is really important: Text, Number or Date.

I just thought it worth pointing out that, for example 8, 70, 600 would sort in one order as Text and the reverse order as Number. Perhaps obvious, perhaps not.”

Sadly Word doesn’t always guess correctly, so you have to check.

Look at these two tables, both are sorted by the Part No. column:

http://img.office-watch.com/ow/Sorting%20by%20Number%20vs%20Text%201.png image from Two ways for sorting by Number at Office-Watch.com


The left table is sorted as if the Part Numbers are numbers from smallest to largest. The right table is sorted as Text. The one you or your company chooses is up to you, but you need to be aware that Word can’t distinguish numbers that are text labels from real numbers (it’s the same problem in Excel PivotTables).

In the Sort dialog for the above tables, Word defaults to Number for the first column

http://img.office-watch.com/ow/Sorting%20by%20Number%20vs%20Text%202.png image from Two ways for sorting by Number at Office-Watch.com

Change the type to ‘Text’ if you prefer.

subs profile e1563205311409 - Two ways for sorting by Number
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address