Hello,
First and foremost,
I'm new here and would like to say thank you beforehand for any assistance you give.
Here is the problem I've got.
I export DOORS requirements to excel 2007,
The requirements are described as
Code:
TEST-1
TEST-34
TEST-24
TEST-100
etc.
When using Excels default A->Z 'sort by' feature I get
Code:
TEST-1
TEST-100
TEST-24
TEST-34
Needless to say what I actually want is
Code:
TEST-1
TEST-24
TEST-34
TEST-100
I find it interesting that I can type
Then highlight and click and drag to get TEST-1 all the way to TEST-X, yet I can't sort by this way, or at least I don't know how.
Again, Many Thanks!