Hi,
Issue is: When i execute a query in SQ01 with output format as Spreadsheet ( i.e. Excel 2007 -Office 2007 is installed), the date and quantity formats are not displayed in Date and Qty format.
For e.x.
If the date is 01/24/2009 and qty is 34,786, in the spread sheet (Excel 2007) i can see
date as 39837 and qty as 34786. These can be changed manually in the excel file using Format cells. But, the requirement is to have it automatically, after download.
When i try it with Office 2003 (excel 2003), There is no problem. It works well.
Our SAP system-Release 4.7.
Please help me in resolving this issue ASAP.
Thanks and Regards,
Senthil Kumar A
Edited by: Senthil Kumar A on Jan 29, 2009 8:11 AM