how to display item numbers that may contain letters

G

gosgood

Using Excel 2003. My item column are refrence numbers to items I am
tracking. Most are straight numbers but some also cntain a leter. (Ex.
204,205,205L, 206K etc.)

How do I format the column so that when sorted 205L shows up right after
205? Currently it will sort the straight numbers fine but the ones with
letter qualifiers will show up at the bottom of the column.
 
E

Elisabeth D

If your reference numbers are stored as text, Excel should prompt you to
specify how you want them sorted. If you select "Sort numbers and numbers
stored as text separately" your numbers should sort they way you want.
 

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

changing column letters to numbers , etc. 3
Changing grey column headings from numbers back to capital letters 2
Unable to sort "words" that are numbers and letters 5
Change Excel column headers from numbers to letters 1
Column chngd fm letters to numbers. What that & how do I go back? 1
column headers changed from letters to numbers, how do I change ba 1
Sort mixed numbers/letters 1
Formulas to display all 3 letter combinations in 8 letters 1

Top