Drving me Crazy

[glometeeb]

Is there a way to get excell to recognize A column these in order?

		1,552,657
		-
05-5000	Metal Fabrications	265
05-7000	Decorative Metal	1,431
06-1000	Rough Carpentry	54,372
06-2000	Finish Carpentry	2,341
06-2500	Prefinished Paneling	127,377
06-4023	Interior Architectural Woodwor	475,010
06-4600	Wood Trim	207,082
06-8316	Fiberglass Reinforced Paneling	13,206
07-9200	Joint Sealants	110
07-9500	Expansion Control	1,777
08-1000	Doors & Frames	296,965
08-3100	Access Doors & Panels	921
08-3300	Coiling Doors & Grilles	12,750
09-6113	Slip-Resistant Flooring Treat	3,595
09-9000	Painting & Coating	37,375
1-003	PMA	1,500
1-008	Project Managment	10,010
1-009	Shop Labor & Deliveries	6,939
1-012	Materials	19,270
1-016	Equipment	8,400
1-076	PER DIEMS	120
1-080	TRUCK USE	24
1-081	MILEAGE	25
1-100	TRAVEL TIME	302
1-700	Cleaning Services	1,000
1-800	Safety	1,000
10-1130	Visual Display Units	31,326
10-2219	Demountable Partitions	95,832
10-2600	Wall & Door Protection	24,881
10-2800	Toilet, Bath, Laundry Access	6,595
10-4413	Fire Protection Cabinets	6,143
10-5116	Wood Lockers	9,126
10-5500	Postal Specialties	1,741
11-3100	Residential Appliances	29,561
11-5213	Projections Screens	28,233
12-9313	Bicycle Racks	11,189
2-001	LABOR	1,344
2-005	SHOP/OFFICE TIME	391
2-010	MANAGEMENT/SUPERVISION	13,162
2-090	MATERIAL HANDLING ON JOBSITE	5,656
2-095	CLEAN-UP	3,944

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[Chino21]

Is there a way to get excell to recognize A column these in order?

		1,552,657
		-
05-5000	Metal Fabrications	265
05-7000	Decorative Metal	1,431
06-1000	Rough Carpentry	54,372
06-2000	Finish Carpentry	2,341
06-2500	Prefinished Paneling	127,377
06-4023	Interior Architectural Woodwor	475,010
06-4600	Wood Trim	207,082
06-8316	Fiberglass Reinforced Paneling	13,206
07-9200	Joint Sealants	110
07-9500	Expansion Control	1,777
08-1000	Doors & Frames	296,965
08-3100	Access Doors & Panels	921
08-3300	Coiling Doors & Grilles	12,750
09-6113	Slip-Resistant Flooring Treat	3,595
09-9000	Painting & Coating	37,375
1-003	PMA	1,500
1-008	Project Managment	10,010
1-009	Shop Labor & Deliveries	6,939
1-012	Materials	19,270
1-016	Equipment	8,400
1-076	PER DIEMS	120
1-080	TRUCK USE	24
1-081	MILEAGE	25
1-100	TRAVEL TIME	302
1-700	Cleaning Services	1,000
1-800	Safety	1,000
10-1130	Visual Display Units	31,326
10-2219	Demountable Partitions	95,832
10-2600	Wall & Door Protection	24,881
10-2800	Toilet, Bath, Laundry Access	6,595
10-4413	Fire Protection Cabinets	6,143
10-5116	Wood Lockers	9,126
10-5500	Postal Specialties	1,741
11-3100	Residential Appliances	29,561
11-5213	Projections Screens	28,233
12-9313	Bicycle Racks	11,189
2-001	LABOR	1,344
2-005	SHOP/OFFICE TIME	391
2-010	MANAGEMENT/SUPERVISION	13,162
2-090	MATERIAL HANDLING ON JOBSITE	5,656
2-095	CLEAN-UP	3,944

<tbody>
</tbody>

Try this link:

http://www.mrexcel.com/forum/excel-...pplications-instead-excels-sort-function.html

 

[glometeeb]

I tried that but I can't get it sort. The 1-003 till 1-800 to be considered the low numbers.

D&D #
05-5000
05-7000
06-1000
06-2000
06-2500
06-4023
06-4600
06-8316
07-9200
07-9500
08-1000
08-3100
08-3300
09-6113
09-9000
1-003
1-008
1-009
1-012
1-016
1-076
1-080
1-081
1-100
1-700
1-800
10-1130
10-2219
10-2600
10-2800
10-4413
10-5116
10-5500
11-3100
11-5213
12-9313
2-001
2-005
2-010
2-090
2-095
2-300

<colgroup><col></colgroup><tbody>
</tbody>