Dear friends i got i eod data.But the data is not updating in my meatstock.Later i found what was wrong with that data and why it was not updating in meatastock.Actually the date has not been separated.For eg. for for 01/01/2004 it was 01012004.Now i come to my question "how to change the date format 01012004 to 01/01/2004 to the data.It is impossible to change it manually from 2000 to 2008 so is there any other way of doing in excel.I have attached a sample file of the data.