Convert Numbers to European Format When Querying from a Database

[antonmarthedal]

I am querying data from a database into a table in Perspective. I have changed the session locale to Danish (da-DK) and also changed the regional settings in Windows to use European number formatting. However, the numbers in my table are still displayed using the American format (e.g., 1,000,000.00 instead of 1.000.000,00). How can I display the numbers using European formatting?

[lucs100]

This looks like a long standing bug. Try the workaround in this post which seems to refresh the number format for the entire page:

[BUG 7305] Perspective Table Number format not changing according to the selected Locale

Hello, I am using Ignition 8.1.23 and facing right now an issue with number formatting inside the Table. When i change the current locale to one using ',' as decimal separator, the number format remains with '.' as decimal separator. [image] so i created a view containing on top a NumericEntryField with the format property not set to none, and below of it a table. Now when i change the locale, the number format of my NumericEntryField is updated and as a side effect of that, the number forma…

[Transistor]

Just a clarification: the problem isn't database related. It's just a problem of rendering the data on the table - no matter where it comes from.

(The question title sounds like you want the query to return the number as a string. This is generally a bad idea, so trying to fix the rendering is a good one!)