C
crys cassano
There are probably more technical ways to solve this one,
but if you're in a hurry, here are a couple simple ways:
1) if this is an existing document that you don't want to
have to retype, try inserting a "0" before each single
digit (i.e., "01," "01a," etc.)--you can do this with a
global search;
2) if you're just starting such a document and want it to
sort when you're done, consider creating two columns: one
for the numeral, the other for the character. Excel will
automatically assume a numeral is a number and naturally
put these in numeric order; then you can simply add
the "a" in the second column. When you format your
report, you can make it appear as if this
numeral/character combination is one entry.
but if you're in a hurry, here are a couple simple ways:
1) if this is an existing document that you don't want to
have to retype, try inserting a "0" before each single
digit (i.e., "01," "01a," etc.)--you can do this with a
global search;
2) if you're just starting such a document and want it to
sort when you're done, consider creating two columns: one
for the numeral, the other for the character. Excel will
automatically assume a numeral is a number and naturally
put these in numeric order; then you can simply add
the "a" in the second column. When you format your
report, you can make it appear as if this
numeral/character combination is one entry.