Unable to format dates in Excel reports
To format the date in the report as required after export to excel, please follow the below mentioned steps: Select the column with the dates in the Excel spreadsheet. Select Data tab on the menu bar and click the button that says ‘Text to Columns’. A wizard will now appear. Select ‘Delimited’ in Step 1 click ‘Next’,…