Apps script and setNumberFormat

Question

I have a Google spreadsheet script that pulls some data through API. The problem is that i'm pulling some data that returns a number like this: 142499.68000000

The problem is that my spreadsheet is configured to brazilian format and i'm getting some crazy results (14.249.968.000.000,00). I want to format this number like this: 142.499,68 (we use comma and not dot as US format).

I've been playing around with .setNumberFormat() but had no success.

How can I format the number like that in my script?

Marios · Accepted Answer · 2020-12-28 21:31:53Z

3

You can use JavaScript directly and in particular Intl.NumberFormat:

function myFunction() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName('Sheet1');
  const cell = sheet.getRange("A1");
  const number = new Intl.NumberFormat('de-DE').format(142499.68000000);
  cell.setValue(number);  
}

It works for me when I change my spreadsheet locale to Brazil.

Make sure you don't have other number formatting on the cells that could affect the formatting returned by the script.

The de-DE version returns the desired result:

edited Dec 28, 2020 at 21:31

answered Dec 28, 2020 at 21:16

Marios

27.5k9 gold badges40 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Apps script and setNumberFormat

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related