Date Format Problems

J

Jennifer W

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
 
R

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
------------------------------------------------------------------------
Jennifer W said:
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
Click to expand...
formatting the cell, but it just doesn't seem to come
 
Top