Microsoft KB Archive/100798

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:02, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

Works: Dates Before 1/1/1900 or After 6/3/2079 Display as ####

Article ID: 100798

Article Last Modified on 11/15/2004


  • Microsoft Works 2.0 Standard Edition
  • Microsoft Works 3.0 Standard Edition
  • Microsoft Works 4.5 Standard Edition
  • Microsoft Works 4.5a
  • Microsoft Works 4.0 Standard Edition
  • Microsoft Works 4.0a

This article was previously published under Q100798


Works for Windows does not recognize dates before January 1, 1900 or after June 3, 2079 as valid entries in the spreadsheet or database. If a date outside of this range is entered in decimal format, the cell displays number signs (####).


Dates are maintained as values from 1.00 (corresponds to January 1, 1900, 12:00:00 AM) to 65534.99999 (corresponds to June 3, 2079, 11:59:59 PM ). The value to the left of the decimal place corresponds to the date; the value to the right of the decimal indicates the time of day. Therefore, formatting any number as a date smaller than 1.00 or greater than 65534.99999 is an invalid entry and will display as pound signs (####).

In Works for Windows versions 4.0 and later, any date that is greater than June 3, 2079 is entered as text.

Additional query words: 2.00 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a error data base spread sheet format dates months days years Jan Jan. June db ss symbol sign # full fill w_works kbimu

Keywords: kbinfo KB100798