Hello,
In SAP BI i have created a BEx Query. We can see BEx reports in MS Excel. Date format in the report is DD/MM/YYYY and i want it to be displayed like YYYYMMDD. Please help me how to write Excel Macro to display the required date format.
Many thanks in advance.
Harry
Configuration: Windows XP Firefox 3.0.11
Change date format excel Change date format in excel 2007 Change date time format excel 2004 for mac Data table excel changing cell color Excel macro conditional formatting formula Excel macro get first row of formula1 Excel using the date format command Export conditonally formatted data to excel in asp.net Exporting data to excel in windows application with formatting Format expiration dates in excel How to apply the short date format in excel 2007 How to change date format in excel Import data .text excel macro without open Macro copy data every excel file in directory Macro to transfer data in excel Microsoft excel change date format from mm/dd/yyyy to dd-mm-yyyy To change date format in php While uploading to excel sheet from vb.net the date format is changing from dd/mm/yyyy to mm/dd/yyyy