Trouble sorting by #

sjoseph08

New Member
Joined
Nov 14, 2005
Messages
1
I have a spreadsheet logging files by box #, file #, status, and name. There is no problem sorting by any of the other fields but when I try to sort by box # it seems to create two seperate sets of info eg. it will sort from 1000-1700 then start at 1000 again and sort another set of info. I have tried reformatting the cells even though I was under the impression that excel will sort but what is in the cell despite any format variation so naturally that didn't work but I am pretty much out of guesses at this point. Some help would be much appreciated.
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Welcome to the Board.

I expect some of your "numbers" are text entries. To convert them click the column header, choose Data|Text to Columns and click Finish.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,377
Messages
5,571,775
Members
412,419
Latest member
acemali
Top