Combobox is changing decimal point from "'," to "."

Hi,

I am using combobox rowsource from listobjects:

Screenshot_7.png

And values are separated with "," - it is consistent with my polish regional settings (comma as decimal point).

But when i am choosing one value from list - combobox automatically converting this to "." as decimal point.

Screenshot_8.png

Why? How to avoid this?
Please help,

Let the Joy be with you,
Thank you in advance,
BEst,
Jacek Antek

You can fetch the values as Text. See the below code if this helps;

Please Login or Register  to view this content.

o thank you!

so the list is taken as number and this is why this is causing the error.
O wow. Hmm what if my list will have thousends of records? Looping throguh all of them ?
It will take a very long time.

Best,
jacek

Great working!!

Best,
Jacek

Another alternative is:

Please Login or Register  to view this content.

Hi,

sorry i have to reopen topic. After change event combobox (even i have values with "," as decimal point) is converting values like "1,67" to "1.67"
Why?

Best,
Jacek

Sorry, my mistake, i had wrong code in after change event.
This code seems to work for me:

Please Login or Register  to view this content.

how can i use listobject here?

Best,
Jacek

Do you mean this ?

Please Login or Register  to view this content.

great thanks!