Please Help.


In Excel I have my date set up as 1022007. All I want to do is make the date as 10/2/2007. However, when I tryed to use format cell, then date. This didn't work. How do I concatenate the date my results should be mm/dd/yyyy when I tryed to insert function using concatenate it then ask for arguements funtions.??? So lost