| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format
Steve Cross wrote in message ... Thanks Mike, I knew about the 'custom' method, but that's not what I was asking. The Date format box contains a different selection of options in every occasion that Excel is installed. It is different on three identical machines in my office with Excel 97 and also at home with Excel 2003. Each one has a different choice, therefore I conclude that there must be some way to change the main list of options rather than going through the 'custom' procedure. Thanks again anyway, and if anyone can show me the way to do what I was trying to do, I should be most grateful for the info. Steve Mike Fogleman wrote in message news:9y5kc.55577$GR.7510515@attbi_s01... You must use the custom list to create a new format. Just modify something that is close to what you want, the way you want it, in the little edit window right above the list. It will not change the original format, it will just add what you modified to the list. This new list of formats will now stay with that workbook, wherever it is opened. Online Help has a lot on this. Mike F "Steve Cross" wrote in message ... When I open Format - Cells - Date, I am given a list of sample date formats. The one I want to use is not in this list. I do not want to use custom, so how do I add to that sample list? When I go to another PC and do the same I get a different list of sample date formats. Thanx in advance..... Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
| change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
| convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
Threaded Mode
