| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
