Issues in localized spreadsheet

Last Updated : Mar 09, 2021 |

Condition

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

Solution

Procedure

  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.

    For information on global number formatting in MS Excel, see https://docs.microsoft.com/en-us/globalization/locale/number-formatting.