Working in Excel2007.

I have a pricelist that I try to sort.

Example:

Art No

6
327
327Q
1017
2245
2245Q
12542

When sorting this normally all articles with the extension "Q" will automaticly be placed last...
After searching the web I found a way to solve this.
http://datapigtechnologies.com/blog/index.php/sorting-numbers-and-text-t...

This present me with another problem.
This will sort the list like this...

1017
12542
2245
2245Q
327
327Q
6
Looks like it only sort by first number and then the second....

What I need is somthing like this.

0006
0327
0327Q
1017
2245
2245Q
12542

Any ideas how to get it to sort it the "right" way?

/ Marco