b_bookg.gif (182 bytes)Guides (MS-Excel97)

Formulae - Year 2000

M-1

Demonstrates: Formatting, Formulae
l_stone.gif (2795 bytes)

Formatting for Year2000

  • Format | Cells | Custom
    [>=36526]m/d/yyyy;[<=36526]m/d/yy;General

If the date is greater than Jan 1, 2000 (serial number 36526), use four digit year, if earlier use 2 digits.

b_ref.gif (1385 bytes)Ref: Walkenbach, J. (1998, Mar)

[Rev 9/3/98] 9/3/98 © 1998 V/2-Com (Verhaart), P O Box 8415, Havelock North, New Zealand.