Issues in localized spreadsheet

Last Updated : Mar 09, 2021 |
Prolog information

Condition

Issues while using excel spreadsheet in a language other than English.

Solution

  1. Go to Control Panel and search for Region.
  2. On Region panel, click Additional settings.
  3. In the Decimal symbol field, change the separator from , to ..
  4. Click Ok.
  5. Save the spreadsheet.
    ADDITIONAL INFORMATION:
    For information on global number formatting in MS Excel, see https://docs.microsoft.com/en-us/globalization/locale/number-formatting.