Decimals problem re: SAP report exported to excel

[former_member564943]

Hi, SAP report [SAP query Trial Balance Comparative (USD to CAD currency)] shows 4 decimals, let's say $12.3456 which is right. But when exported to excel (.xls), it shows 2 decimals as 1234.56 which was multiplied by 100. We have 2 users, one user's excel shows correct decimals while the other shows wrong as multiplied by 100. Is this related to GUI patch or just excel settings? how can it be fixed?

[former_member564943]

Good to know. Thank you.

[iklovski]

Hi,

I agree with Bastiann, should be linked to Excel settings. Check this OSS note, for example:

1912461 - Export to excel does not format currency correctly

Also, does it happen when you export to local file or to XLS? Does it happen for specific currency or for all numbers, where you have, say, only two allowed decimals?

Regards,

Eli

[former_member564943]

It was resolved. Thanks Eli and Bastiaan for the input - help analyze the issue from different angles. There was no problem when exported to local file, and it is only for USD.

[iklovski]

It is advisable to close the thread when the issue is resolved.

[former_member564943]

Sure. Will do. Just haven't figured out how to close it.

[JL23]

see my blog: What to do with my answered questions?

[Former Member]

Have one user try it on the other computer to check for excel settings. I would expect excel and usersetting (SAP) combinations to be the cause.

[paolo_baruffaldi]

maybe it depends on user settings:

SU01 transaction , Defaults, change Decimal Notation

an alternative is to export the file in .xlsx format instead of .xls

[former_member564943]

Thanks Tammy and Paolo for the answer. However, the problem is not solved yet.

[TammyPowlas]

Try this: "The simplest solution is to download a tab separated file and then open this in Excel."