Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi
Regarding Excel export in spreadsheet format (not direct export) is fundamental in order to avoid problems, to follow the following simple rules:
1) export report in spreadsheet format (to avoid confusion don't use extension .xls I usually use .slk)
2) Open Excel, select the menu File-Open and follows the steps for the import selecting correct attributes for each comumn
If you save the file as .xls and make double click on it, Excel is opened automatically and the import is managed directly by it. The result is the loosing of leading zeros on codes columns and the wrong import of some dates (not all).
Regards
Rocco
| | | ---------------Original Message---------------
From: Arunrnair
Sent: Monday, June 20, 2011 2:50 PM
Subject: Vlooking up SAP download in Excel
Hi,
You can download the data by using option of "Export to spreadsheet" wherein you will get the date as it is in SAP which includes prefix zeros.
Thanks
Arunrnair |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  RTUCCELL
SAP Accounting Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Popular White Papers
In the Spotlight  _.____.__ |
