Aaaaargh! This can be frustrating in reporting out of SAP into Excel: decimals are considered thousands separator or numbers are not recognized at all as a number. There are three settings involved. To properly solve this issue:
- first check what is the standard decimal figure used in your company. Then check if this is also used in SAP (System > User profile > Own data ).
- then check the regional settings of Windows (in XP look in Control Panel). The regional settings also determine the decimal settings. Make sure this is also in sync.
- finally check Excel options (Tools > Options ). Either use system settings or enter the figures manually.
Now you are set to avoid frustration.