[accnpc]

My company is using SAP as our production software. When I download data from SAP into Excel 2007, numbers are not showing correctly. Colons are where periods should be, and numbers that had 3 decimal places showing are now showing 15 decimal places with a colon instead of decimal. Help please.

[Nic Cunliffe]

You have the option in SAP to set certain user defaults

Menu: system>user profile> own data. In here, you can specify some selections. When you download data from SAP, select unconverted as the file format and then use text wizard to import to excel. The delimiter is often a comma but sometines | (above my backslash key on my PC). Depending on which version of SAP you are using, R2 / R3 / R4, other options are available. Let me know how you go on and if this does not work, I can give you some other things to try? Which transaction are you using in SAP?

Nic

[accnpc]

It doesn't appear to be a transactional error. I have tried downloading from several different modules in sap and get the same issue. I tired changing user settings and still get the same problem. I am enclosing a small file to show what I am seeing.