Posted to microsoft.public.excel.misc

Lorene Schertzl

Posts: n/a

Cemetery birth and death date sort

I am transcribing a cemetery and want to be able to sort by birth and death
date. Right now a have all dates entered as yyyy-mm-dd.eventually this will
be posted on line for geologists. It would be much better if it were in the
format of day, month,year (28-Apr 1893). I have downloaded the xDate add in
for Excel dates before 1900 (hope I installed it correctly). Running Excel
2002

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I sort dates in Excel	Lorene Schertzl	Excel Discussion (Misc queries)	1	March 15th 06 04:08 PM
bar graph showing year of birth and death of several people	Tom Gettys	Charts and Charting in Excel	3	September 5th 05 05:11 PM
How do I get Excell to sort dates that range from 1800 to 1900's	Smith295	New Users to Excel	1	February 22nd 05 06:20 PM

All times are GMT +1. The time now is 11:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us