Posted to microsoft.public.excel.misc

Barb

external usenet poster

Posts: 70

All numbers won't sort

I am sorting numbers in a column. All are formatted number. When paint the
column to sort, there are some numbers that will sort and others don't so
anything.

They look like below:

79668
79672
79762
73025
73026
73027
73033
73042
73050
73057
75028
75029
75031
75053
75057
79637
79638
79639

Why won't they all sort?

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
How can i sort a database on numbers?	Sylvester	Excel Worksheet Functions	3	August 1st 06 07:15 PM
Sort numbers by the first integer	skiman123321	Excel Discussion (Misc queries)	5	July 28th 06 06:39 PM
Sort numbers	JTH	Excel Discussion (Misc queries)	5	September 29th 05 12:47 AM
How can I sort by numbers and not text?	Arsenal	Excel Worksheet Functions	1	September 20th 05 11:47 PM
sort + & - numbers together	Rasoul Khoshravan Azar	Excel Worksheet Functions	1	December 18th 04 11:11 PM

All times are GMT +1. The time now is 11:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us