for those with just a year, format the cells as yyyy
Then, when you sort, it will sort correctly, 1492 will appear before July 4,
1776...

"Craig" wrote:

I am preparing a time line in Excel 2003. I want the left column to reflect
the date and be sortable but I need two different types of dates. One might
be "July 4, 1776" or simply the year "1492".

thanks for any help...jcs