Convert spreadsheet decimal number format: period- and comma-separated decimal positions

google-sheets number-formatting openoffice-calc
Gene Arboit picture Gene Arboit · Jul 24, 2014 · Viewed 27k times · Source

In OpenOffice Calc, one can change number format between standard United States, with decimal separator being a period ., and the SI (International System) format with decimal separator being a comma ,. This can be done by setting the language to US-English in the first case, and to Canada-French in the latter case (in the Format menu).

    13.3        13,3
    2.2         2,2

Openoffice-calc

How can the same be done in Google Spreadsheets?
It does not seem that language can be changed within a same sheet (or maybe a same Google account ...?).
Is there another way?

Copy-paste from OO to Google does not work:

    13/03/2014      13,3
    02/02/2014      2,2

Answer

pnuts picture pnuts · Jul 26, 2014

I dispute that comma as the decimal separator is " the SI (International System) format " - rather than one of ;-) - but think what you want is:

File > Spreadsheet settings ... and for Locale: choose somewhere like Canada (French).

Though beware, this could have ramifications beyond , for ..

Related questions

How to highlight cell if value duplicate in same column for google spreadsheet?

I am looking for formula for google spreadsheet highlight cell if value duplicate in same column can anyone please assist me for this query?

Read More
Conditional formatting based on another cell's value

I'm using Google Sheets for a daily dashboard. What I need is to change the background color of cell B5 based on the value of another cell - C5. If C5 is greater than 80% then the background color is green …

Read More
How to get the correct range to set the value to a cell?

I want to set text or number in Google Sheet from script. I want to set Hello or number 9 in cell F2. I found this code so far: SpreadsheetApp.getActiveRange().setValue('hello'); but that doesn't specify which cell.

Read More