# Convert Numbers to European Format When Querying from a Database **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [July 3, 2026, 12:47pm UTC](https://forum.inductiveautomation.com/t/convert-numbers-to-european-format-when-querying-from-a-database/116262 "2026-07-03T12:47:19Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![lucs100](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lucs100/32/86254_2.png) [@lucs100](https://forum.inductiveautomation.com/u/lucs100)\ **Post date:** [July 3, 2026, 1:14pm UTC](https://forum.inductiveautomation.com/t/convert-numbers-to-european-format-when-querying-from-a-database/116262/2 "2026-07-03T13:14:37Z")
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](https://forum.inductiveautomation.com/t/bug-7305-perspective-table-number-format-not-changing-according-to-the-selected-locale/70657): > > 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. 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… --- _[View the full topic](https://forum.inductiveautomation.com/t/convert-numbers-to-european-format-when-querying-from-a-database/116262)._