Google Script number format in Google Docs

Asked Jun 22 '17 at 07:21

Active May 02 '19 at 21:59

Viewed 1,456 times

I'm currently generating a google document with Google Script.

I have an issue with number formats. I have a table with currency values, so I tried to format the text like this ( like how I'd do it normally ):

var number = 12345;
var currencyString = number.toLocaleString(); // This 'works' but outputs : 12345
var euroCurrencyString = number.toLocaleString("nl-NL", { style: 'currency', currency: 'EUR' }); // This throws exception

But it throws this exception: TypeError: InternalError: Illegal radix 0.

Is there any other way to format a number to a currency string? ( eq; € 12.345,00 )

EDIT: toLocaleString() actually works, I just mistyped it

edited May 02 '19 at 21:59

Rubén

34,714
9
70
166

asked Jun 22 '17 at 07:21

Arthesian

Remove the "s" in `toLocalseString`. – str Jun 22 '17 at 07:25
derp, I edited my question :) toLocaleString() seems to work, but does not output it in a way I want it to. When I supply parameters to it, it fails. – Arthesian Jun 22 '17 at 07:36
`.toLocaleString()` (without arguments) doesn't even seem to work. I can't get it to display anything other than `[object String]`. – Sinjai Sep 23 '19 at 21:03
I have the same issue. Did anyone solve it? – ndreisg Apr 14 '20 at 11:10

Google Script number format in Google Docs

0 Answers0