How to change date format in excel report time stamp
But i want to show as dd-mm-yyyy
1. excel sheet generally takes the same format of display as your own system. this format can be changed using "reason & language" option as shown in screen shot 11.
2. If first option did not workout then second method is custom option. In excel Ypu will find one "general" option. click on that 1 pop up window as shown in attached screen shot 12 will come. There You can got the "date" & "Custom" option. That will 100% resolve your date format issue.