MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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:


Where A1 is the cell containing the text "070601"

Then format the cells to be dates