Can I enter a date without using the / or hyphen?

[Guest]

I am trying to format a cell so I can type in the date without the slash or
dash. If I enter the date without these, it changes my date to some strange
number. What is going on? Why is this so hard to figure out?

 

[pfsardella]

I haven't tried this AddIn myself, but a few people that frequent this
newsgoup put it together.

QDE.xla Version 1
http://www.rondebruin.nl/qde.htm


HTH
Paul

 

[Myrna Larson]

It's "so hard to figure out" because it isn't possible.

Formatting a cell with a date format doesn't limit entries in that cell to
dates. Therefore, whenever you enter a date -- regardless of the cell format
-- you must enter it in such a way that Excel recognizes it as a date. That
means you must use date separators or month abbreviations. e.g. if you type
12122004, there's no way for Excel or anyone else to know whether you meant
the date Dec 12, 2004, or the number 12,122,004.

The only way around this would be to use a VBA macro to "look at" what you
have typed and translate it into a date.