Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I enter a date without using the / or hyphen?
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? |
#2
|
|||
|
|||
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 -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- 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? |
#3
|
|||
|
|||
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. On Sun, 12 Dec 2004 10:13:02 -0800, "mscpa" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |