Wingz Technical Support Bulletin Number 005
             
             
            Title:    Entering dates prior to 1900
            Date:     October 11, 1990
             
            If you try to enter a date that is prior to 1900, 
            12-30-99 is placed in the cell.  The work around is
            as follows.
             
            Suppose you wanted to enter the date 11-17-1755.  If 
            you type it in a cell, 12-30-99 appears. Use the date
            function to enter the date. The date function accepts
            three numeric arguments.
             
                      date(year,month,day)
             
            To enter 11-17-1755, enter the date via the following
            formula.
                      =date(1755,11,17)
             
            This formula results in a negative number which
            actually represents the julian date for 11-17-1755.
             
            Create a custom format using the following picture.
             
             
             
                      mmmm d   yyyy
             
            Format the cell containing the date formula with the 
            custom format and the result is November 17, 1755.