Hiiii Guys I am stuck in one problem i have copy a huge data from web but some field are converting in different way, Actual Value is 5-6 in web and after paste in sheet Convert in 05-Jun, i have tried format cells but not getting Sucess, anyone resolve this problem, if its solution is in format cell then how.