Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Entering DATEs in EXCEL should not require use of "/" slashes.
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I generate random numbers using dates in excel? | Excel Worksheet Functions | |||
Excel not recognizing Dates properly. | Excel Discussion (Misc queries) | |||
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
how do I show dates in a column in an excel worksheet? | Excel Discussion (Misc queries) |