View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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.