Thread: How to change the default format for date?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How to change the default format for date?
StartSettingsControl PanelRegional and Language Options.

Adjust default under Regional OptionsCustomise.


Gord Dibben MS Excel MVP

On Sat, 29 Sep 2007 06:50:00 -0700, Eric wrote:

Does anyone have any suggestions on how to change the default format for date?
The default format for date is mm/dd/yy, does it come from the OS?
How to change the default date format into dd/mm/yy?
Thanks in advance for any suggestions
Eric

Reply With QuoteReply With Quote