How can I sort Excel pre 1900 dates

  Biji 09:41 08 Sep 2006

Excel in XP only appears to accept dates of 1900 onwards as proper dates, 1900 being 1 according to the help files. Doing family history I want the prog to accept dates prior to 1900 and to be able to sort them. Is this possible, please

  Gongoozler 09:57 08 Sep 2006

Excel doesn't make it easy. Apparently this is because Excel was originally designed to be compatible with Lotus 123. There is a sort of work-around here click here

  ArrGee 10:03 08 Sep 2006

Would it be feasible to place the day/month/year in separate cells as opposed to a date in a single cell?

  VoG II 13:43 09 Sep 2006

Format the column that holds the dates as Text.

Select all of your dates, Data > Text to Columns, choose Delimited with the Other option, / as delimiter.

Then follow ArrGee's suggestion.

  Noldi 14:43 09 Sep 2006

click here

Some more info


  Noldi 14:50 09 Sep 2006

Sorry Gongoozler
didnt see your click here you already had it. That is a great adin if you work with dates.


  Biji 13:47 25 Sep 2006

Thanks, folks.

I couldn't get on with XDATE - it appears ticked on the 'add-ins' list but I can't make it do anything - Any suggestions, please?

I have managed using Vor's instruction followed by AarGee's and then using CONCATENATE to put the separate colums back together plus fill down for a block, so am making progress.

Any further advice you may care to offer would be much appreciated though.

  Noldi 16:54 25 Sep 2006

click here
Found this but have not tried it yet.

  Biji 16:18 26 Sep 2006

Thanks, Noldi - works well and fairly quick to do so

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?