K
Krestine Corbin
I have a spreadsheet with a single column that contains
numbers/text as follows: 1,2,2a,2b,3,4,5,5a,5b,5c,6 etc.
When I go to sort the spreadsheet, the whole numbers are
at the top (1,2,3,4,5 etc) and the numbers with letters
are (in order) at the bottom). Obviously this ruins my
spreadsheet because rows are now out of order.
I know that this column needs to be formatted as "Custom"
in the number formatting area so that Excel recognizes
that there is a number with text, but for the life of me I
can't figure out how to do it. The formats already listed
don't work, and I've attempted to create one, but have had
no luck at all.
Any ideas out there?
Thanks. -K
numbers/text as follows: 1,2,2a,2b,3,4,5,5a,5b,5c,6 etc.
When I go to sort the spreadsheet, the whole numbers are
at the top (1,2,3,4,5 etc) and the numbers with letters
are (in order) at the bottom). Obviously this ruins my
spreadsheet because rows are now out of order.
I know that this column needs to be formatted as "Custom"
in the number formatting area so that Excel recognizes
that there is a number with text, but for the life of me I
can't figure out how to do it. The formats already listed
don't work, and I've attempted to create one, but have had
no luck at all.
Any ideas out there?
Thanks. -K