Data/Text to Columns/Next/Next select YMD from the Date dropdown and
click Finish.

In article ,
bustanutti21
wrote:

hi everyone.. can anyone tell me how to change the date format in
Excel.. I tried going to Format then cells and changing the format to
Date but it's not working... I'm pulling the date from an online
program and the date comes in as 20050507 instead of 05/07/2005...
If anyone can help me with this i would be oh so greatful... thank