Yes but with genealogy you open up another can of worms because they
would be text dates instead of Excel dates. John Walkenbach has
Extended Date subroutines because VBA handles dates better than Excel
so you can have a date before 1900 and then you have calendar changes
occurring at different dates around the world.
http://www.mvps.org/dmcritchie/excel/datetime.htm

and
Extended Date Functions
http://www.j-walk.com/ss/excel/files/xdate.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"I don't know but probably Lorraine O'Del" <I don't know but probably Lorraine wrote in message
...
The date format - yyyy mmm dd (month being letters) is the most common and
most useable format for people using the date as a sort and/or search method,
particular in genealogy. I'm tired of having to see the date in the opposite
direction I want it. I want to see the year first, then the Month in a 3
letter abbreviation,then the days. An acceptable compromise would be yyyy mm
dd - then punctuation would be necessary to make the numerals more readable.
Thank you.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...et.f unctions