change date format in Excel template
Hi all,
I have a 2003 Excel template. In my XML file, date format is 15-Apr-2024, client would like the format changed on Excel template to 04/15/2024. the Date is stored as a text in sql query. How can I change date format automatically. Client does not want to change format each time report is ran.