Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to enter date without using "/" each time?
How do I enter a date in a cell without having to push the "/" between the
month, day, and year? |
#2
|
|||
|
|||
If you just don't like that character, use the dash (-) instead. Anything
else is probably more complicated and time consuming than it's worth. Excel needs to know where to 'draw the line' between day, month & year. LOL |:) "magstate" wrote: How do I enter a date in a cell without having to push the "/" between the month, day, and year? |
#3
|
|||
|
|||
Using VBA code.
Chip Pearson has the code. http://www.cpearson.com/excel/DateTimeEntry.htm Alternative....download the QDE add-in from Ron de Bruin's site. http://www.rondebruin.nl/qde.htm Gord Dibben Excel MVP On Wed, 23 Mar 2005 10:03:01 -0800, "magstate" wrote: How do I enter a date in a cell without having to push the "/" between the month, day, and year? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |