date formatting

Posted by Airedale98 on July 16, 2001 10:20 AM

Is there a way to enter a date without hyphens or slashes (ex. 071601) and excel to format it to 07/16/01? I'm sure there is a formula. Thanks for the help.

Posted by Dana on July 16, 2001 11:48 AM

One way to do it would be:

=LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,2)

Where A1 is the cell containing the text "070601"

Then format the cells to be dates