Author Topic: Excel pre 1900 dates  (Read 565 times)

Offline Lensmeister

  • RootsChat Senior
  • ****
  • Posts: 250
  • Searching Family History & WTFC info
    • View Profile
Excel pre 1900 dates
« on: Friday 01 June 18 12:48 BST (UK) »
I have a HUGE database of info on DOB etc, which I have many dates Prior or 01/01/1900.

Excel is not recognising the years 1899 (or earlier) as a legitimate date ....

I used to have a macro that did actually make Excel recognise the date but I no longer have it.

Anyone able to offer a solution ?
Hugkulstone: All
Stogdon, Preedy, Harris, Jenkins, Thaler, Vail, Brown (Whitby), Browne (Sussex), Infield, Feldwick, Knowles, Dodman, Nicholls, Anderson, Dell, Brooker, Purvey, Gibb, Cox. Wifes Side:Burningham, Hill, Sanger, Morrison, Mulholland, Legg, Lake, Ewence, Gurd, Bowden.
And Whitby Town Players.

RootsChat is the busiest, largest free family history forum site in the country. It is completely free to use. Register now.
Also register instantly with Facebook or Twitter (and other social networks). Start your genealogy search now.


Online Rosinish

  • RootsChat Marquessate
  • *******
  • Posts: 9,670
  • PASSED & PAST (Speciality - South Uist, Inverness)
    • View Profile
Re: Excel pre 1900 dates
« Reply #1 on: Friday 01 June 18 12:52 BST (UK) »
Format either General or Text?

Annie
South Uist, Inverness-shire, Scotland:- Bowie, Campbell, Cumming, Currie, MacDonald, MacInnes, MacIntyre, MacKinnon, Steele, Walker

Ireland:- Cullen, Flannigan (Derry), Donahoe/Donaghue (variants) (Cork), McCrate (Tipperary), Mellon, Tol(l)and (Donegal & Tyrone)

Newcastle-on-Tyne/Durham (Northumberland):- Harrison, Jude, Kemp, Lunn, Mellon, Robson, Stirling

Kettering, Northampton:- MacKinnon

Canada:- Callaghan, MacKinnon, MacPhee

"OLD GENEALOGISTS NEVER DIE - THEY JUST LOSE THEIR CENSUS"

RootsChat is the busiest, largest free family history forum site in the country. It is completely free to use. Register now.
Also register instantly with Facebook or Twitter (and other social networks). Start your genealogy search now.


Offline hallmark

  • -
  • RootsChat Marquessate
  • ****
  • Posts: 10,511
    • View Profile
Re: Excel pre 1900 dates
« Reply #2 on: Friday 01 June 18 12:56 BST (UK) »
Yes.... use OpenOffice which is free!   ;D ;D
.
.
.

Online philipsearching

  • RootsChat Aristocrat
  • ******
  • Posts: 2,914
  • I was a beautiful baby, - what went wrong?
    • View Profile
Re: Excel pre 1900 dates
« Reply #3 on: Friday 01 June 18 13:07 BST (UK) »
Yes.... use OpenOffice which is free!   ;D ;D

Agreed!  BUT - if you use "save as" and save the file in MSExcel format then open it later with Excel, would you lose the date formatting?  OR - if you save the file in OpenOffice format would you be able to open it later with Excel?
Census information is Crown Copyright http://www.nationalarchives.gov.uk


Towcester/Weedon - ALLEN, BASFORD, MAY       Fakenham - WILLIAMSON       Hempton - WRIGHT, LOVELL       Bethnal Green - MONKS and LARCHER
Southwark - MOUNT, BOWBRICK        Clonakilty to Southwark -  CRISPIN      Lambeth - LYON       Hoxton - WALTERS     Gwennap - JAMES, GRAY, TREWARTHA       Antrim - CORDNER, SANDYS         Peru - SOTELO, MOREY, BASELLI

Offline Lensmeister

  • RootsChat Senior
  • ****
  • Posts: 250
  • Searching Family History & WTFC info
    • View Profile
Re: Excel pre 1900 dates
« Reply #4 on: Friday 01 June 18 13:10 BST (UK) »
The dates are stored as 01/01/1899 etc.

Hugkulstone: All
Stogdon, Preedy, Harris, Jenkins, Thaler, Vail, Brown (Whitby), Browne (Sussex), Infield, Feldwick, Knowles, Dodman, Nicholls, Anderson, Dell, Brooker, Purvey, Gibb, Cox. Wifes Side:Burningham, Hill, Sanger, Morrison, Mulholland, Legg, Lake, Ewence, Gurd, Bowden.
And Whitby Town Players.

Offline hallmark

  • -
  • RootsChat Marquessate
  • ****
  • Posts: 10,511
    • View Profile
Re: Excel pre 1900 dates
« Reply #5 on: Friday 01 June 18 13:12 BST (UK) »
Yes.... use OpenOffice which is free!   ;D ;D

Agreed!  BUT - if you use "save as" and save the file in MSExcel format then open it later with Excel, would you lose the date formatting?  OR - if you save the file in OpenOffice format would you be able to open it later with Excel?

Don't have Excel.

Haven't used Excel for years and years.

Offline hallmark

  • -
  • RootsChat Marquessate
  • ****
  • Posts: 10,511
    • View Profile
Re: Excel pre 1900 dates
« Reply #6 on: Friday 01 June 18 13:16 BST (UK) »
Can send it to anyone who is "afraid of change"

.
.


Offline hallmark

  • -
  • RootsChat Marquessate
  • ****
  • Posts: 10,511
    • View Profile
Re: Excel pre 1900 dates
« Reply #7 on: Friday 01 June 18 13:19 BST (UK) »
The dates are stored as 01/01/1899 etc.

That's why I used 1800's dates!!

Offline Lensmeister

  • RootsChat Senior
  • ****
  • Posts: 250
  • Searching Family History & WTFC info
    • View Profile
Re: Excel pre 1900 dates
« Reply #8 on: Friday 01 June 18 13:20 BST (UK) »
My excel WTFC database is 22607KB and has many macros, long formulas and look ups.

Hugkulstone: All
Stogdon, Preedy, Harris, Jenkins, Thaler, Vail, Brown (Whitby), Browne (Sussex), Infield, Feldwick, Knowles, Dodman, Nicholls, Anderson, Dell, Brooker, Purvey, Gibb, Cox. Wifes Side:Burningham, Hill, Sanger, Morrison, Mulholland, Legg, Lake, Ewence, Gurd, Bowden.
And Whitby Town Players.