Posted to microsoft.public.excel.misc

DoxieLvr

external usenet poster

Posts: 1

Excel Sorting Order

Is there a way in Excel to set up a sort so that the sort is done by digit?

The following list of numbers
2024
2032
2008
2016
20008
2020
20020
20032
2012

when sorted ascending would typically appear sort like this
2008
2012
2016
2020
2024
2032
20008
20020
20032

The desired sort is this
20008
20020
20032
2008
2012
2016
2020
2024
2032

Help!!!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing the sorting order...	Conrad C.	Excel Worksheet Functions	4	April 18th 07 06:54 PM
Sorting by date order	Jock W	Excel Worksheet Functions	3	October 18th 06 01:01 PM
sorting data in order	ceemo	Excel Worksheet Functions	1	July 6th 05 12:13 PM
sorting in order	ceemo	Excel Worksheet Functions	2	June 30th 05 05:48 PM
sorting in order	ceemo	Excel Worksheet Functions	0	June 30th 05 01:20 PM

All times are GMT +1. The time now is 08:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us