Decimal separator

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:

  1. 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 ).
  2. 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.
  3. finally check Excel options (Tools > Options ). Either use system settings or enter the figures manually.

Now you are set to avoid frustration.

XP control panel

XP control panel

Advertisements

2 thoughts on “Decimal separator

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s