How to change the default format for date?
 

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

How to change the default format for date?
 

You could try changing a windows setting.

In WinXP Home
Go to the control panel
Regional and language options
Regional Options Tab|click the customize button
Change the short data format to the order that you want.


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

--

Dave Peterson

How to change the default format for date?
 

Be aware that this windows setting affects all of windows--you'll see the dates
in the same order in windows explorer (for example).

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

--

Dave Peterson

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