Using Excel for parts stocklist

[bwanasonic]

If anyone else here uses Excel for keeping track of parts on hand, I'm wondering if there any tips on getting values to sort.

This is the way Excel wants to sort:

Capacitor, Electrolytic   2.2uf
Capacitor, Electrolytic   220uf
Capacitor, Electrolytic   22uf

I know this would work, but I'd rather not:

Capacitor, Electrolytic   002.2uf
Capacitor, Electrolytic   022uf
Capacitor, Electrolytic   220uf

Any stupid Excel tricks to get pf/nf/uf to sort in the *right* order ?

Kerry M

[Samuel]

put the value in a seperate field tagged to be numeric?

[Khas Evets]

I had the same problem and did the same thing as Samuel. Have one description column and one value column. If you have a very long list you can extract the number using this function where X is the cell of the descrption =MID(X,25,LEN(X)-25-2). You could also use an if statement to calc pf (/1000000), nf (/1000) and uf.

[1wahfreak]

Yes, if you put the type of cap in one column, value of cap in another column and units in another, you can use the "filter" funtion. To do this, highlight any cell with data in it.
Then choose "data" from the menu list. You'll get a drop down box for each one of the columns (in this case three). Simply choose what you want to sort by. I'm not sure if all versions come with the filter option. For older versions, you may have to load the add-ins. Let me know if it works or not.

[StephenGiles]

This may help you:
http://216.92.17.166/board2/viewtopic.php?t=47129&postdays=0&postorder=asc&start=10&sid=749c493325b5ca19b177587b59b74cff#javascript:void(0);
Stephen

[StephenGiles]

Actually, if you delete the uf in each case it will sort as you require, but then if you have pf in there as well, it's of no use. Aladin on the Mr Excel site will find a solution for you.
Stephen