Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Entering dates QUICKLY
How do I enter dates without using the / key. Eg 071004 instead of 07/10/04
(this could of course be any date). I have seen applications set up this way, but I have not been able to find a reference to how it is done. Any ideas? |
#2
|
|||
|
|||
http://www.cpearson.com/excel/DateTimeEntry.htm
-- Kind Regards, Niek Otten Microsoft MVP - Excel "DOMINIC JOSLIN" wrote in message ... How do I enter dates without using the / key. Eg 071004 instead of 07/10/04 (this could of course be any date). I have seen applications set up this way, but I have not been able to find a reference to how it is done. Any ideas? |
#3
|
|||
|
|||
Hi Dominic
there is probably an eay way to do this - but I dont know it. However two alternatice approaches. 1. Use an adjacent cell to parse the input and generate a valid date. eg =DATEVALUE(LEFT(F16,2) &"/" & MID(F16,3,2) &"/" & RIGHT (F16,4)) where F16 contains a DDMMYYYY "date" input. 2. Use the worksheet change event: You need to stop it going into an endless loop. this is done by turning off events while processing the change: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Application.EnableEvents = False If Target.Column = "3" And Target.Value2 < "" Then Target.Value = DateValue(Left(Target.Value2, 2) & "/" & Mid(Target.Value2, 3, 2) & "/" & Right(Target.Value2, 4)) End If Application.EnableEvents = True End Sub |
#4
|
|||
|
|||
Dominic,
There is an addin called QDE (Quick Date Entry), could be just what you want :-) http://www.xldynamic.com/source/xld.QDEDownload.html -- HTH RP (remove nothere from the email address if mailing direct) "DOMINIC JOSLIN" wrote in message ... How do I enter dates without using the / key. Eg 071004 instead of 07/10/04 (this could of course be any date). I have seen applications set up this way, but I have not been able to find a reference to how it is done. Any ideas? |
#5
|
|||
|
|||
Hi
use the following addin: http://www.xldynamic.com/source/xld.QDEDownload.html -- Regards Frank Kabel Frankfurt, Germany "DOMINIC JOSLIN" schrieb im Newsbeitrag ... How do I enter dates without using the / key. Eg 071004 instead of 07/10/04 (this could of course be any date). I have seen applications set up this way, but I have not been able to find a reference to how it is done. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel | |||
Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
Dates | Excel Discussion (Misc queries) | |||
How do I import fractions without data being converted to dates? | Excel Discussion (Misc queries) | |||
Dates in spreadsheets | Excel Discussion (Misc queries) |