I am following the steps to download data to excel from SAP Query. My SAP version is 4.7 and Excel on my PC is MS OFFICE EXCEL 2007.
Steps after getting report output on screen-
1. List -> Spreadsheet
2. Choose Table for Radio button
3. Choose Microsoft Excel
This gives me all data correctly except the date formatting and columns starting with zero.
->Date format column is automatically taken as General and the dates shown are garbage values.
->the column in which data starts with zero comes without leading zeros and data integrity is lost.
Please give any suggestions that you may have to resolve this problem.