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

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

Craig

Excel does not recognize dates prior to 1900 so you must be entering July 4,
1776 as text.

Sorting will not take place as you wish.

For working with dates prior to 1900 see John Walkenbach's site.

http://www.j-walk.com/ss/excel/usertips/tip028.htm


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 15:29:25 -0500, "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