Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 Is there any way to change these thousands of dates to the way that I want them? I tried reformatting the columns |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How I sort data in Excel, it keeps saying "merged cells must be ID | Excel Worksheet Functions | |||
how to sort date in excel | Excel Worksheet Functions | |||
Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
Excel should remember sort criteria | Excel Worksheet Functions | |||
Excel not recognizing Dates properly. | Excel Discussion (Misc queries) |