Format the numbers - thousand separator

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

So after entering, it is not formatted

Check this: thousand2.aia (115.6 KB)

Oh, you want it in the textbox, sorry, not paying attention

However, you will probably need to give something else the focus (another textbox) in order to activate the lostfocus

Besteht die Möglichkeit mit Ihnen über Whatsapp kurz telefonieren?