drops leading zeros on SAP download

Downloading from SAP to Excel 2003, only dollars were treated as numbers, 
other fields were Text.  Excel 2007, all fields that appear to be numbers are 
treated as numbers and any leading zeros are dropped.  Is there a solution 
other than to customize every column/field.
0
Utf
3/11/2010 12:04:01 AM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
1121 Views

Similar Articles

[PageSpeed] 13

Reply:

Similar Artilces:

Problem downloading messages from new account
Hi I have 2 accounts already set up on Windows live and they are fine. I have just added a new IMAP account which said was successful but when I try to download the messages I get the error message: Your IMAP command could not be sent to the server, due to non-network errors. This could, for example, indicate a lack of memory on your system. What does this mean. I have lots of memory on my system - where do I start looking for clues? Thanks Tina Are the other 2 accounts also IMAP with the same mail service? With some mail services (e.g. Gmail) you have to enable IMAP for th...

Void a cash payout or drop
The void function only lets me void a sale. How can I void a payout? Merchants Consultings offer a wide range of consulting services, from system design to automation to reporting. If you need help with any aspect of RMS, chances are we can provide you with the knowlege you need. http://www.merchantsconsulting.com "rgj" wrote: > The void function only lets me void a sale. > How can I void a payout? > What if you do a "pay in" - ie do another payout but put a negative dollar amount matching the original pay out. I've never done this myself but it ...

Subform comparison of 2 tables excluding non zero value
I am creating a subform (Access 2003/NT) in which the user will type in a Melt# (contained in the tblChemicalResults). I need to create a side by side comparison of the chemical requirements from the tblChemicalRequirements to the actual results contained in the tblChemicalResults, but I need it to exclude any non zero values from both tables. Each table contains all of the possible 14 different metal elements that could possibly go into making a particular part. Obviously, not all 14 go into every part, so how do I display only the elements that have a non zero value while also display...

Dynamic chart- curve dropping to zero ( chart type- Line)
Hi all i using following formula and description for the dynamic chart. Please do the needful In B1 = Project start date , C1= Mar-10 In B2= Project duration , C2= 30 ( which may vary) In B3= Project Cost , C3= 10000000 In C6=+IF(ROW()-ROW(C$6)+1<=C$2,DATE(YEAR(C$1),MONTH(C$1)+ROW()-ROW(C$6),DAY(C$1)),"") Till C50 In D5=IF(OR(B6="",B6=0),"",B6/$C$2) till d50 In e5=IF(OR(D6="",D6=0),"",IF(D6<=33.33%,(($I$1*D6^2)*100),IF(D6<=66.67%,($I$2*D6+$I$3),IF(D6>=66.67%,($I$4+$I$5*D6+$I$6*D6^2)*100,"")))), till E50 I...

Emails downloading but not showing in inbox
A strange thing has started happening today. When I click send and receive Outlook 2003 shows email coming in i.e. 1 of 20 etc. but nothing shows up in the inbox at all! I am using Outlook 2003 connected to an Exchange 5.5 server and am downloading both internal mail as well as external POP. I have checked and even reset the view settings. I can't find where the email is going and cannot receive email as of today. Any ideas? ...

How to eliminate from Outlook Address Book drop down list
When I create a new message, and select the "To" button, Many categories show up that either I created individual folders in the past in contacts, or the categories no longer exist in my outlook. How do I eliminate those from showing up in the drop down list? Thanks, TJ Go to properties of the ones you want to remove and untick "show this folder as an e0mail adress book". Jet >-----Original Message----- >When I create a new message, and select the "To" button, Many >categories show up that either I created individual folders in the >past in c...

Drop Down List #3
I use drop down lists with many bits of information. When I open the lists after they have been used, the list does not go back to the first enty in the list. What do I need to do to make the list default to the first enty? -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17623 View this thread: http://www.excelforum.com/showthread.php?threadid=476762 you can select the cell and press delete,or right click and choose clear contents, this will reset it Th...

Visio Viewer 2003 now available for download!
http://www.microsoft.com/downloads/details.aspx?FamilyID=3fb3bd5c-fed1-46cf-bd53-da23635ab2df&DisplayLang=en Microsoft has released the latest version of the Visio Viewer, compatible with Microsoft Office Visio 2003 and all previous versions of Visio back to Visio 5.0. Currently the English language release is available with other languages to follow. Microsoft Internet Explorer 5.0 or later is required for the viewer. -- Mark Nelson Microsoft Corporation This posting is provided "AS IS" with no warranties, and confers no rights. Outstanding! Thanks Mark. Randall Arno...

Downloading from Bank Site
Maybe I'm missing something here. I'm downloading from my bank site by saving to hard disc, then loading into Money, but I'd prefer to download directly into Money.. I have the accounts setup in Money for active downloading but, when I select "Open Active Statement" the site does it's thing but where does the download go? It doesn't show transactions to be reconciled in my Accounts List. Am I being coherent here? In microsoft.public.money, cam wrote: >Maybe I'm missing something here. I'm downloading from my bank site by >saving to hard disc,...

Download problems from CD
I recently purchase Money 2006 Deluxe and have not had any luck installing the program. I keeps asking for a QM.dll file that I can't find. Any help would be greatly appreciated. ...

Partially invoicing a Drop-Ship Order Linked to a Drop-Ship PO
Can you partially invoice a drop-ship order in SOP that is linked to a drop-ship PO? We received an invoice from one of our vendors that was for a drop- ship PO we issued to them. They did not ship the complete order...only a partial. We matched the partial invoice to the drop- ship PO and processed it, but now need to invoice the customer for the partial. In the drop-ship order in SOP, it shows the quantity fulfilled for the line item as the amount from the vendor invoice, but in the Quantity to Invoice field, it shows the total quantity ordered when the customer placed the order. Is the...

adding specific "Lead Source" contact or account to Lead form?
The Lead form has a "Lead Source." When the lead source is "External Referral" we'd like to track the actual Contact (or Account) so we can send them a thank you or special offer. How can we create a "Lookup" attribute (relationship?) from the Lead to a Contact and put it on the Lead form for the user to select a lead source contact from the search Contacts form? Would using the Referral field help? -- Larry Lentz [CRM MVP] MCSE+I, MCSE W2K, MCDBA, MCSA Messaging Lentz Computer Services Microsoft Small Business Specialist San Antonio, Texas Larry@LentzCo...

Set a default value to Drop Down Box
Is it possible to set a 'default' value to a drop down box, so that n matter what value was selected when it was saved, when the workboo opens it changes to the default value? I have a written a macro to do this for all the input cells that ar not drop downs, but cannot figure out a way to change values in dro down forms. Thanks Bria -- Message posted from http://www.ExcelForum.com What's the default value? The first on the list? If yes: Option Explicit Sub auto_open() Dim wks As Worksheet Dim myDD As DropDown For Each wks In ThisWorkbook.Worksheets ...

Help requested
I'm a new user of Microsoft Money 2006, and one of the things that sold me was the ability to automatically download transactions from various financial institutions via Yodlee. Unfortunately, while Money offers a lot of choice of financial institutions to auto-download from, it doesn't seem to be complete. There are a lot of institutions that you can enable for integration from Yodlee directly (via the OnCenter at Yodlee.com). Yodlee, for example, offers integration with lesser known financial institutions like Buyandhold.com and Nationwide Financial. These two do not appe...

Outlook Express downloads all email to one family user
I've set up a new PC. All of my Epxress POP3 and SMTP information is entered correctly, and I have entered five email addresses into Express (one Main account and four others) My problem concerns receiving email. When logging into Express, all undelivered email for all five accounts is downloaded to the first account Express opens. For example, there are six pieces of underlivered email this morning -- two addressed to the "Dad" account and four addressed to the "Mom" account. Child 1 opens Express and signs into his account and the six emails are downloaded to the...

How do I change the format in a excel drop box?
I have used a list in a validation drop box, but the text size when veiwing the list is very small. How do I increase the text size in the drop box? Once a item is selected off the list it is shown in the validation cell as per the cell format. I have tried to change the format in the list, but this doesn't change the viewed size of the validation cell drop box. Not possible, a workaround is found here http://www.contextures.com/xlDataVal08.html#Larger -- Regards, Peo Sjoblom (No private emails please) "steve.southcoal" <steve.southcoal@discussions.microsoft.com>...

How do i create a multiple choice drop down list
I have been trying to put together an Excel Sheet giving multiple answers on a drop down table. Any suggestions would be very much appreciated. Thanks A. You can use Data Validation to create a dropdown list. There are instructions in Excel's Help, and here: http://www.contextures.com/xlDataVal01.html Piper wrote: > I have been trying to put together an Excel Sheet giving multiple answers on > a drop down table. Any suggestions would be very much appreciated. Thanks A. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Deb...

How do I keep emails at provider's site and still download to Outl
I would like to keep my emails at my Comcast account and still download them to Outlook. That way I can get to them from my laptop when not at home. I am using Version 2003 - SP3 You can do this by connecting via IMAP or, when using POP3, set the option to leave a copy on the server. See http://www.msoutlook.info/question/160 -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/ Outlook FAQ, HowTo, Downloads, Add-Ins and more http://www.msoutlook.info/ Real World Questions, Real World Answers ----- "KPalmer...

Chart not to pull Zero's
I am working on an Excel Chart that has future months showing with a Zero dollar value and it is charting the future months on my chart. Is there a way to get it so that the Zero's will not show up? I have a formula that is pulling the amount from another chart. Thank you for your help. Change "" to NA() in your formula. This puts #N/A into the cells, which is unattractive in the worksheet, but which is not plotted on a line or XY chart. =IF(A1=0,NA(),A1) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ __...

Account not selected when coverting leads
There are 3 options to chose when converting a lead - account, contact and opportunity. If you do not select the account, can you do so at another time? Is there any way to create the account after converting if it was not selected? The Opportunity has to be linked to a particular account as it is a required field in Opportunity. The best thing to do is to create a default account and call it "None" or anything you like and get the users to set the opportunities that has no accounts when creating the opportunities to it as a temp account then insert the correct info in the...

User enters number and 3 zeros are added at end of number
Hi all, I've done some vba programing and created a few Spreasheets and workbooks but this one eludes me. I'm trying to get Excel to take a user enter number for example 15 and automatically make it 15,000. Does anyone have an idea of how to acomplish this? I have to save the user some data entry work. Rui How about using a worksheet_change event in the sheet module and multiply the target *1000? -- Don Guillett SalesAid Software donaldb@281.com "Township of East Hanover" <someone@somewhere.com> wrote in message news:IJudnd4fBbxOkWHdRVn-hA@garden.net... > Hi a...

How to re-download emails from server to outlook 2007
I need to re-download emails that are in the server but got deleted from my inbox some time ago. I tried http://support.microsoft.com/kb/227054 but I cant find those *.rhc files. BTW: I am paying the price of upgrading to Windows 7 and using Outklook 2007. I have ISP and the emails are available using web-email Thanks -- JuanK That kb applies to Outlook2k, not 2007 Configure Outlook with the ISP Mail account. Mail doesnt get deleted unless you delete it, excepting if its an imap account "JuanK" <JuanK@discussions.microsoft.com> wrote in message news:E7E...

What if I want to re-download the mails I have deleted on user end
maybe it is a question about sync. how to sync with the server as if it was the first time I open WLM? Hi, Hollan. Are you using Hotmail? Or is this a POP3 email account? Or Yahoo or Gmail or ... ? POP3 is the only one that I'm familiar with. WLMail is set, by default, to "Leave a copy of messages on server". You can change this setting at Tools | Accounts | <your account> | Properties | Advanced. But, if you are using POP3 and if you have left the messages on the server, you can re-download them from there into WLMail. If that is not what you are...

Problem with a drop down window for a ccomboboxex
Hello Everyone, I'm facing a problem with a CComboBoxEx.... I've implemented a deskband & i want to include a feature like the auto-suggest feature as in the google toolbar. My problem is that when some strings are populated in the drop down & I do a show drop down, my edit control in loses focus. I'm adding strings in my function (which is called in response to a CBN_EDITCHANGE message). After populating the strings, I call CMyCombobox->ShowDropDown (TRUE); But then, my edit box loses focus. If I do an immediate SetFocus (), my drop down window disappears. Any Idea ...

Problem downloading Excel template
When trying to download Excel templates from Microsoft Website, I keep getting this error message: "Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience." I am using Excel 2000. I believe my IE6 browser is set to accept cookies. I have ASAP Utilities installed, but should that make a difference? Any help appreciated. Thanks You should pick "Save" for the download, not "Open". -- Jim "Chris Burgess" <Chris Burgess@discussions.microsoft.com> wrote in message news:DCB61A6E-287B-4527-8...