when i sort my column in numerical order, it starts out fine, i.e 01-01,
01-02. However, when it gets to 10-01, i get 10-01, 100-01,100-02, etc,
without any rhyme or reason. How do i set to sort 01-nn through 99-nn befor
going to 100-nn and beyond
when i sort my column in numerical order, it starts out fine, i.e 01-01,
01-02. However, when it gets to 10-01, i get 10-01, 100-01,100-02, etc,
without any rhyme or reason. How do i set to sort 01-nn through 99-nn befor
going to 100-nn and beyond
Excel's help explains it.
I searched for: Default sort orders
Apostrophes (') and hyphens (-) are ignored, with one exception: If two text
strings are the same except for a hyphen, the text with the hyphen is sorted
last.
One way around it (maybe???) is to use a helper column with a formula in it.
Then sort your data by that helper column.
If your data is in A1:Axx, put this in that helper column (row 1):
=--SUBSTITUTE(A1,"-",".")
And drag down.
Then sort by that column. Since the data is now numeric, it should work ok.
column sorting wrote:
>
> when i sort my column in numerical order, it starts out fine, i.e 01-01,
> 01-02. However, when it gets to 10-01, i get 10-01, 100-01,100-02, etc,
> without any rhyme or reason. How do i set to sort 01-nn through 99-nn befor
> going to 100-nn and beyond
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks