/
Decimal Mismatch

Decimal Mismatch

Windows System and Excel Decimal Settings


If Excel was installed in a different language than the default Windows language, you may receive the following message:


To resolve this, complete the steps below:

  1. Click File at the top left of Excel:

  2. Click Options:



  3. Click Advanced (1) and adjust Excel’s decimal system to match Windows by unchecking Use system separators (2):



  4. Click OK at the bottom-right and close/reopen Excel:



  5. After SigmaXL loads, ensure no traces of the previous decimal system are cached by clearing SigmaXL's Saved Defaults (SigmaXL > Help > SigmaXL Defaults > Clear Saved Defaults).








Related content

Multiple decimal systems and SigmaXL
Multiple decimal systems and SigmaXL
More like this
Troubleshooter - SigmaXL for Windows
Troubleshooter - SigmaXL for Windows
More like this
Mac - Regional and Language Settings
Mac - Regional and Language Settings
More like this
Numeric column headings
Numeric column headings
More like this
All the options in SigmaXL dialogue boxes are grayed out yet can be selected
All the options in SigmaXL dialogue boxes are grayed out yet can be selected
More like this
Download previous or unsupported versions of SigmaXL
Download previous or unsupported versions of SigmaXL
More like this