Excel formatting

L

LoriM1

I am trying to sort a spreadsheet. I want it to sort like this:

1112
1112a
1113

It will only sort:

1112
1113
112a

How do I fix this?
Thanks!
Lori
 
J

JanetW

If you put an apostrophe in front of each number, it will allow you t
treat it as either text or a number when you sort (Excel will ask yo
how you want it treated)
 
M

Maurice

Should you have a very long list to sort you could try adding an extr
column. add a comma, drag down and fill with commas in a futher colum
=CONCATENATE(B3,A3) i.e
A
1112 , = ,1112
1113 , = ,1113
1112a, = ,1112a

you can the extend and sort on the new colum
 
Top