How to sort column

[abid]

Hi everybody,
I am sure somebody must have posted the answer for this
question earlier.

I am having difficulty of sorting one column in my
spreadsheet. I have numeric data in that colum like
numbers 1-100 and then other data like 1-a, 1-b and 2-a 2-
c. I want to sort it like first cell it should show me 1
and then next cell 1-a and 1-b and 2 then 2-a and 2-b.
But
I am sorting it, data is coming like this first 1-100
numbers and then starting again with 1-a and 1-b but I
want that to be 1 and 1-a. I changed that colum to text
but still not working.
Pls help me with this.
Thanks in advance
abid

 

[abid]

My excel sheet look like this
45
55
6
7
3
2
89
1-a
1-c
45-d
67-c
I want to sort it like this
1-a
1-c
2
3
6
7
Pls help how to do it?
thanks

 

[immanuel]

Changing the cell format won't change the data type. To sort your data, I
suggest something like the following:

With your data in A1:A100:

B1: =A1&""

Fill down to B100. Then copy B1:B100 and Paste Special as "Values" into
B1:B100.

Now sort just B1:B100. You'll get a prompt asking you what to do with
numeric values. Choose the radio button that tells XL to treat all of your
values as text.

/i.