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?

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?

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?