hey u can do one thing in excel select the column in which u r showing the date, then click on for example A column so that the entire A column gets selected then right click and select format cell then click the tab number then select date then set the format as per ur wish it will set the property for that column permanently. hope it helps
Prakash Mishra(Banglore,India)