Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ben Rum
 
Posts: n/a
Default Format Cells - Date options

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   Report Post  
CyberTaz
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtract a group of cells from a total based on ending date Nicholas Scarpinato Excel Discussion (Misc queries) 0 May 17th 05 03:25 PM
Count cells based on date range in another column [email protected] New Users to Excel 1 May 5th 05 08:11 PM
Australian date format in Excel 2000 Brian Jones Excel Discussion (Misc queries) 2 March 30th 05 06:13 AM
Min/Max formulas using cells with date format WDS2000 Excel Worksheet Functions 1 February 7th 05 06:03 PM
problem with formatting cell to date format Del Excel Worksheet Functions 7 December 8th 04 05:14 PM


All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"