Newbie can't sort 830 records by date

jaybostonusa

New Member
Joined
Jul 4, 2006
Messages
15
I wouldn't bother you if this wasn't my last resport (sorry). But I have 830 records with the DATE and "time of call" in the far left column. I want to sort these 830 records into chronological order. But when I do a search, these records are sorted by the first number in the month and not the year. What can I do?

First record:
11/12/06 9:37 AM
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
I think it should work. How were those entries made? Typed in or downloaded from a database?

Try selecting the column and going to Data|Text to Columns and clicking Finish. Then try re-sorting. Does that work?
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Did you try the Data|Text to Columns thing?

Also, are there spaces before and/or after the entries?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,061
Messages
5,545,763
Members
410,704
Latest member
Cobber2008
Top