https://community.graphisoft.com/t5/Collaboration-with-other/IS-Excel/m-p/22271#M1849 I have yet to see items sorted as you want them in Windows (creating an ordered list in Excel is different from sorting after the fact). You are looking for true alpha<I></I><S><I><I></I></I></S>numeric<E></E> sorting rather than the straight alpha sort that most things do.<BR /> <BR /> The MacOS (since 10) handles this very nicely but not all Mac apps do. You may be out of luck unless you can separate the alpha from the numeric and concatenate them after two sorts (possible in a database but I'm not sure how to do it in the IS or Excel). Tue, 03 Apr 2007 06:05:27 GMT Anonymous 2007-04-03T06:05:27Z https://community.graphisoft.com/t5/Collaboration-with-other/IS-Excel/m-p/22270#M1848 <DIV class="actalk-migrated-content"><T>In my plan I have a series of parts that I need to list ascending with IS... <BR /> These parts are labeled by the user and are listed in IS using a common ID. What I need to see is....<BR /> A1<BR /> A2<BR /> etc.<BR /> A9<BR /> A10<BR /> A11<BR /> <BR /> What I get is...<BR /> A1<BR /> A10<BR /> A11<BR /> A2<BR /> A3<BR /> <BR /> I thought that I could fix it by resorting it in Excel after exporting. Unfortunately Excel sorted in the same manner. The odd thing is that if I type A1 into a cell in excel then grab the bottom right corner of that cell and drag it downward(fill down I think) it gives the results I'm looking for. This seems a little strange to me....any thoughts?</T></DIV> Tue, 03 Apr 2007 01:57:07 GMT https://community.graphisoft.com/t5/Collaboration-with-other/IS-Excel/m-p/22270#M1848 Anonymous 2007-04-03T01:57:07Z https://community.graphisoft.com/t5/Collaboration-with-other/IS-Excel/m-p/22271#M1849 I have yet to see items sorted as you want them in Windows (creating an ordered list in Excel is different from sorting after the fact). You are looking for true alpha<I></I><S><I><I></I></I></S>numeric<E></E> sorting rather than the straight alpha sort that most things do.<BR /> <BR /> The MacOS (since 10) handles this very nicely but not all Mac apps do. You may be out of luck unless you can separate the alpha from the numeric and concatenate them after two sorts (possible in a database but I'm not sure how to do it in the IS or Excel). Tue, 03 Apr 2007 06:05:27 GMT https://community.graphisoft.com/t5/Collaboration-with-other/IS-Excel/m-p/22271#M1849 Anonymous 2007-04-03T06:05:27Z https://community.graphisoft.com/t5/Collaboration-with-other/IS-Excel/m-p/22272#M1850 Easiest Windows solution is to pad the numeric portion with zeroes as needed... so A01, A02, ... A10, A11 etc...<BR /> <BR /> Not what you wanted, I know...<BR /> <BR /> Karl Tue, 03 Apr 2007 17:50:28 GMT https://community.graphisoft.com/t5/Collaboration-with-other/IS-Excel/m-p/22272#M1850 Karl Ottenstein 2007-04-03T17:50:28Z https://community.graphisoft.com/t5/Collaboration-with-other/IS-Excel/m-p/22273#M1851 You're right Karl, not what I wanted but I might be able to make it work. I understand whats going on now....thanks all for your help!!! Wed, 04 Apr 2007 00:18:20 GMT https://community.graphisoft.com/t5/Collaboration-with-other/IS-Excel/m-p/22273#M1851 Anonymous 2007-04-04T00:18:20Z