Date Format Problems

[Guest]

Is there anyway to make excel change the numbers I type in to the appropriate date? If I type
112603, how can I get the cell to display 11/26/03. I have tried formatting the cell, but it just doesn't seem to come
out right. Any help would be greatly appreciated. Thank you

 

[Gord Dibben]

Jennifer

Only through VBA. See Chip Pearson's website.

http://www.cpearson.com/excel/DateTimeEntry.htm

Gord Dibben XL2002

 

[RWN]

Assuming A4 = Text format, value= 112603 (mmddyy) and you always enter
in this format (i.e. Jan = "01" vs."1")
C4 formatted as whatever date format you prefer (in my case yy-mm-dd)
C4 = "= DATE(RIGHT(A4,2),LEFT(A4,2),MID(A4,3,2))"
Year Month Day

C4 becomes "03-11-26"


--
Regards;
Rob
------------------------------------------------------------------------

Is there anyway to make excel change the numbers I type in to the appropriate date? If I type
112603, how can I get the cell to display 11/26/03. I have tried

formatting the cell, but it just doesn't seem to come