Data Extraction not sorting properly

[profcad]

I'm doing a data extraction with a block with attributes. When I extract the data, it sort like the image below. I want it to sort 1,2,3,4,5,etc...

 

Any ideas on how to fix this problem.

[ReMark]

Can't you bring the data into Excel and sort it there?

 

Another option is discussed in post #2 of this thread...http://forums.autodesk.com/t5/AutoCAD-2007-2008-2009-DWG/numerical-data-sort-in-data-extraction/td-p/2395309

Edited November 21, 2013 by ReMark

[profcad]

I found the solution...Thanks for the help.

 

Change the column data format to "Whole Number".

 

[ReMark]

Strange. I tried that on my test drawing and it didn't work that's why I did not mention it. Must have done something wrong. Glad you found a solution and thanks for sharing the knowledge.

 

Oops, it just dawned on me why it did not work. I tried that option AFTER exporting the data to a table. Duh! Thanks again.

[minhphuong_humg]

I have a drawing with dimesions. I want extract dimensions, howerver I don't known? Please!

Drawing:

Hoi.dwg

I want file excel (export):

1A6 42

1A7 42

..............

1A28 44

Please, help me.

Thank you very much.