You can use this Add-in if you enter a lot of dates
http://www.rondebruin.nl/qde.htm

Or from
http://www.xldynamic.com/source/xld.QDEDownload.html



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Receptionist" wrote in message ...
When entering a date INTO A CELL FORMATTED FOR DATES, one ought to be able
to simply enter 09122005 (or 091205) instead of being required to enter
09/12/2005 (or 09/12/05). As long as the cell is properly formatted, the
figures entered should be accepted as being the numbers for a date in that
format. (This should work, for example, in the same way as data entered into
a cell which is formatted for percentages: The program reads the data
entered, and re-formats it.)
This should not work if the cell was NOT formatted for dates, of course,
so that numbers can be entered as text or as other data.

[At present, the program 'translates' digits entered into a date calcuated
from an arbitrary starting point, using the entered data as if it were a
number of days to be added to that date. No real person uses dates that way.
The program should accomodate real people, not visa-versa.]


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc