Excel formatting

  • Thread starter Thread starter LoriM1
  • Start date Start date
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
 
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)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add identifiers to a list of numbers 5
Filling series 2
trying to find a way to make duplicates and add identifiers to a 5
Sorting 2
Copy data and paste to different sheet named on Group 1
Countif 1
Count of values within a cell? 1
sort multiple columns of data but not change the data location... Possible? 3

Back
Top