Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to recognise dates prior to 1/1/1900 ?
As title asks. Family Tree information finds some earlier dates fail to be
recognised and formatted as such. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to recognise dates prior to 1/1/1900 ?
Excel does not recognize pre-1900 dates as other than text. You might check
out this add-in from John Walkenbach which will help: http://www.j-walk.com/ss/excel/files/xdate.htm -- Jim "Gazz" wrote in message ... | As title asks. Family Tree information finds some earlier dates fail to be | recognised and formatted as such. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to recognise dates prior to 1/1/1900 ?
See http://j-walk.com/ss/excel/usertips/tip028.htm
Always type full question in the message space not the subject line -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Gazz" wrote in message ... As title asks. Family Tree information finds some earlier dates fail to be recognised and formatted as such. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to recognise dates prior to 1/1/1900 ?
I would recommend that you use text so that they will not change; however,
if you want to risk using a macro John Walkenbach wrote Extended Dates routines Excel does not recognize dates before Jan 1, 1900 and mishandles leap year in 1900 so for simply calculating date differences (age) you might use John Walkenbach's XDATEDIF Extended Date Functions Add-In, instead of DATEDIF, eliminating problems with negative dates involving subtraction in MS date system and incorrect leap years in older MS 1900 date system. http://www.j-walk.com/ss/excel/files/xdate.htm You calculations can be further complicated by when a country switched calendars. 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 "Gazz" wrote in message ... As title asks. Family Tree information finds some earlier dates fail to be recognised and formatted as such. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to recognise dates prior to 1/1/1900 ?
Gazz
See John Walkenbach's site for working with dates prior to 1900. Download his Extended Date add-in. http://search.atomz.com/search/?sp-q...6ae-sp00000000 Gord Dibben Excel MVP On Wed, 16 Nov 2005 14:15:44 -0800, "Gazz" wrote: As title asks. Family Tree information finds some earlier dates fail to be recognised and formatted as such. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to recognise dates prior to 1/1/1900 ?
Excel's normally formatted dates only go back that far. You can use custom
add-ins or just use Julian dates ( without fancy formatting and support functions. -- Gary's Student "Gazz" wrote: As title asks. Family Tree information finds some earlier dates fail to be recognised and formatted as such. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to recognise dates prior to 1/1/1900 ?
Thanks all. Lots to go on there.
Not expecting dates to change as they're not used in calculations. That column just indicates briths, marriages, deaths, etc.. Might be better in a database really, but I'm more used to Excel. Will look up the links etc. this evening. Cheers |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to recognise dates prior to 1/1/1900 ?
Ah ha ! Took a while to work though the "Insert / Function / Date&Time"
stuff, think the diagram is for an earlier version of Excel. Doesn't work automatically I see, has to be entered =XDATE(year,month,date,"format"), but hey ! It works :-) A quick Global Replace should sort things out : sorted, thanks. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get Excel to recognise dates prior to 1/1/1900 ?
Ah and I have now discovered how to send a reply to one and not all :-)
Live & learn. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel dates prior to 01/01/1900 | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
fractions turn into dates when pasting in excel 2003 | Excel Discussion (Misc queries) | |||
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) |