| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 98523 | 2009-03-27 23:43:00 | Microsoft Excel 2003 date format in dd/mm/yy | zillah (13701) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 760144 | 2009-03-27 23:43:00 | Hi How can I change date format (javascript:void(0)) in Excel (javascript:void(0)) 2003 to dd/mm/yy (28/03/09),,,,there is no such an option in Format --> Cell (javascript:void(0)) --> "Number" tab (javascript:void(0)) --> Type,,,,and there is no such an option in "Regional Settings" |
zillah (13701) | ||
| 760145 | 2009-03-27 23:50:00 | Have a look under Format, cell, Date | Sweep (90) | ||
| 760146 | 2009-03-28 00:31:00 | Have a look under Format, cell, Date there is no such an option in Format --> Cell (javascript%3cb%3e%3c) --> "Number" tab (javascript%3cb%3e%3c) --> Type The correct order should be Format --> Cell (javascript%3cb%3e%3c) --> "Number" tab (javascript%3cb%3e%3c) --> Date --> Type |
zillah (13701) | ||
| 760147 | 2009-03-28 00:34:00 | Well sorry. I was using Excel 2007. I take it you have it working now? | Sweep (90) | ||
| 760148 | 2009-03-28 00:43:00 | If you have Windows regional settings correct (control panel) it will be automatically dd/mm/yy type format | godfather (25) | ||
| 1 | |||||