Custom List
Hi Connie
I can't figure a way to do with Custom Lists, but you could use a helper
column.
In the helper column enter
=IF(LEN(A1)=4,A1&"-1",A1)
and copy down
Mark your data including the helper column, and sort by the helper
column.
After sorting, delete the helper column.
--
Regards
Roger Govier
"Connie Martin" wrote in
message ...
I want to create a new custom list in Tools/Options that will sort a
list of
numbers with dashes in this way:
1383
1769-7
1794-8
1849-1
1913
1957
1962-1
1977-3
1996-1
2009-2
2020-1
2051
2077-2
2079-2
2102-1
2121-1
2126-1
2129-1
2130-1
2135
2139
2161-2
2169-2
2179
2180
How do I have to set up my custom list so it sorts like this?
Connie
|