Using Excel 97 SR-2 under Windows 95 (not a problem under Windows 98, NT 4 or W2K), if you have a cell formated with any date format displaying a two-digit year at the end (i.e. 3/4/97 or 04-Mar-97), when you enter a new value or edit an existing value, the format for the cell is changed to "custom" and having the same date layout except for the year being change to a four-digit display (i.e. 3/4/1997 or 04-Mar-1997). Anybody know anything about this obnoxious "feature"? I find nothing about it at the Microsoft site...
Thanks,
Rich
Thanks,
Rich