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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Trouble sorting by #
- Thread starter sjoseph08
- Start date
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.
I expect some of your "numbers" are text entries. To convert them click the column header, choose Data|Text to Columns and click Finish.
Upvote
0
Similar threads
- Question
