Format Cells - Date options

[Ben Rum]

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.

 

[Guest]

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 |:>)