| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change default format | Charts and Charting in Excel | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| How do I change the default number format ? | Excel Discussion (Misc queries) | |||
| How to manage/change the default month/day date format? | Excel Discussion (Misc queries) | |||
| How do I change the default date format in an Excel Footer | Setting up and Configuration of Excel | |||
Linear Mode
