G GB Jul 30, 2003 #1 How do I change the default date format to show yyyy rather than yy, please? Geoff
G Gord Dibben Jul 30, 2003 #2 Geoff That is controlled by Windows settings. Make changes at Control Panel>Regional Settings for "Short Date" Gord Dibben Excel MVP - XL97 SR2 & XL2002
Geoff That is controlled by Windows settings. Make changes at Control Panel>Regional Settings for "Short Date" Gord Dibben Excel MVP - XL97 SR2 & XL2002
G GB Jul 31, 2003 #3 Gord Dibben said: Geoff That is controlled by Windows settings. Make changes at Control Panel>Regional Settings for "Short Date" Click to expand... Thank you Gord, that does the job perfectly. It never occurred to me to alter the short date setting to the same as the long date setting. It has obviously had some effects on windows elsewhere, but hopefully these are livable with. Geoff
Gord Dibben said: Geoff That is controlled by Windows settings. Make changes at Control Panel>Regional Settings for "Short Date" Click to expand... Thank you Gord, that does the job perfectly. It never occurred to me to alter the short date setting to the same as the long date setting. It has obviously had some effects on windows elsewhere, but hopefully these are livable with. Geoff
G Gord Dibben Jul 31, 2003 #4 I have never run into any Application that objected to the "short date" settings being same as "long date". Gord
I have never run into any Application that objected to the "short date" settings being same as "long date". Gord