Sometimes when you import data in CSV, excel, ods files from other sources then GoogleSheets may fail and shows the number as plain text. This may lead to calculations error. General separators used with numbers are thousands separator and decimal separators.
A thousand Separators are normally used for large numbers which improves readability.US, Great Britain, Thailand uses a comma to indicate a thousand places. France, Germany, Italy, and many more uses space to indicate a thousand places.
Decimal Separators are used to separate the integer parts from fraction parts.US, Great Britain, Thailand uses a period (or dot) to indicate the decimal place. France, Germany, Italy, and much more use comma to indicate the decimal places.
First open Google Sheet with Data as shown below.
click on File > Spreadsheet settings
Under General Tab, click on Local Dropdown select desire Locale.
This Locale affects formatting details such as functions, dates, DateTime, Time, Percent, and currency.
By default, it has the United States in my case.
Popular locale and example are as follows.
|Canada (French)||1 234 567,89|
|Finland||1 234 567,89|
|France||1 234 567,89|
|Germany||1 234 .567,89|
|Sweden||1 234 567,89|
Click on Save settings
Then it will reload the page and will see the effect. You can add a new number and you can see those effects as soon as you are out of the cell.
Output for Locale: France
Set Locale in Android and iOS
Currently, we cannot set the locale using Google Sheet Mobile Application. To change your sheet’s locale settings, open it in Google Sheets on your computer.
Complete List of Google Sheet Locale
- Canada (English)
- Canada (French)
- Hong Kong
- India (Bengali)
- India (Gujarati)
- India (Kannada)
- India (Malayalam)
- India (Marathi)
- India (Panjabi)
- India (Tamil)
- India (Telugu)
- Myanmar (Burma)
- Norway (Norwegian Bokmål)
- Norway (Norwegian Nynorsk)
- South Korea
- Spain (Catalan)
- United Kingdom
- United Kingdom (Welsh)
- United States