Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is is possible to alter the list of standard Date formats in the list that
appears when you select "Format - Cells - Date"? I rarely use any of these ones, and have to enter in a custom format, which Excel doesn't remember next time I ned to format a date column. Alternately, It would also be helpful, that when I enter a custom format, it saved it to the list. Excel 2000. |
#2
![]() |
|||
|
|||
![]()
Hi Ben-
Custom formats are not added to the default categories, but they should be retained in the Custom category at the bottom of the list. You can reapply it from there whenever necessary. To keep from having to dig for it, you may want to consider defining it as a Style. HTH |:) "Ben Rum" wrote: Is is possible to alter the list of standard Date formats in the list that appears when you select "Format - Cells - Date"? I rarely use any of these ones, and have to enter in a custom format, which Excel doesn't remember next time I ned to format a date column. Alternately, It would also be helpful, that when I enter a custom format, it saved it to the list. Excel 2000. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
Count cells based on date range in another column | New Users to Excel | |||
Australian date format in Excel 2000 | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
problem with formatting cell to date format | Excel Worksheet Functions |