View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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