Format the numbers - thousand separator

i want to get this block.

call

So that the numbers can format. 1000000.00 to 1.000.000,00 € or 1.000.000 km

example in Google Script what I mean:

So where is the problem?

The problem is, I can’t find the “call” block anywhere

Here’s a blocks-only solution …

nnn Thousandizer.aia (2.6 KB)

1 Like

Thank you, I will test it

Try this: thousand.aia (9.8 KB)

grafik

Very nice, that’s what I wanted. Didn’t work in my program, I suspect the settings. I also want the format to be generated during antipping;) in the textbox. I really appreciate your help. Have a nice Day :sun_with_face:

Hi, I partially solved the problem with the decimal separator. The problem is still when I enter a round number of more than 999 and leave the input field, it then cuts the decimal value after the comma. For example, at 999 makes: 999.00 and with a number from 1000 that makes: 1,000 (so not like 1,000.00).
The decimal separator disappears and only a thousand separator appears. Do you know how I can combine the blocks so that I keep dicimal and thousands. So when you leave the field: 1,000.00 It doesn’t matter which type of separator you use.
grafik

Try something like this:

The problem (as I said) only with round numbers. If I do as you tell me and manually enter numbers behind the comma, I have the following result :frowning:
grafik

I am changing one problem to another

I need a mathematical solution and not a system trickery :wink:

Here’s a solution, do you know who is the author? It must be allowed to put a comma even with longer (and round) numbers.

That is a thousand and decimal definition, the problem is that they cannot be combined with ROUND numbers from 1000 digits.

It is not a maths thing, because the number starts out and finishes as text.

Here is a workaround that should handle all cases:

test right away :slight_smile:

Please be aware that when formatted like this you have a string, and not a number. If the number is important, you will need to save this separately.

Unfortunately, this does not work, when you leave the texbox, the data remains as tapped

grafik