date format changing to custom upon data entry

richapple · Apr 22nd, 2002, 10:10 AM

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

Anne Troy · Apr 22nd, 2002, 11:42 AM

Sounds like perhaps you've got your regional settings set to short date as mm/dd/yyyy. Check in the control panel for your regional settings.

richapple · Apr 22nd, 2002, 11:55 AM

Thanks, Dreamboat. I had already checked that and the short date setting via the Regional Settings is the two-digit date already...

Thanks,
Rich

Apr 22nd, 2002, 11:42 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Sounds like perhaps you've got your regional settings set to short date as mm/dd/yyyy. Check in the control panel for your regional settings. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 10:10 AM	#1
richapple New Member Join Date: Apr 2002 Location: Rich Apple Posts: 2	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

Apr 22nd, 2002, 11:55 AM	#3
richapple New Member Join Date: Apr 2002 Location: Rich Apple Posts: 2	Thanks, Dreamboat. I had already checked that and the short date setting via the Regional Settings is the two-digit date already... Thanks, Rich