| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with date input
I've searched through the questions, but cannot find a logical explanation.
I've recently upgraded to Excel 2003, but for whatever reason it is usin mm/dd/yyyy format as the default, rather than dd/mm/yyyy. I have checked, double checked and checked again my regional settings which are EN (UK) and have dd/mm/yyyy as the default, but it still won't change in Excel. Anyone got any suggestions why? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problems with date input
Try changing the format in Excel - it might be in mm/dd/yy format.
"timbloke" wrote: I've searched through the questions, but cannot find a logical explanation. I've recently upgraded to Excel 2003, but for whatever reason it is usin mm/dd/yyyy format as the default, rather than dd/mm/yyyy. I have checked, double checked and checked again my regional settings which are EN (UK) and have dd/mm/yyyy as the default, but it still won't change in Excel. Anyone got any suggestions why? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| show latest date input only | Excel Discussion (Misc queries) | |||
| Problems with date calculations (bank hols etc) | Excel Discussion (Misc queries) | |||
Linear Mode
