# Convert Numbers to European Format When Querying from a Database

**URL:** <https://forum.inductiveautomation.com/t/convert-numbers-to-european-format-when-querying-from-a-database/116262>\
**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:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonmarthedal](https://avatars.discourse-cdn.com/v4/letter/a/8edcca/32.png) [@antonmarthedal](https://forum.inductiveautomation.com/u/antonmarthedal)\
**Post date:** [July 3, 2026, 12:47pm UTC](https://forum.inductiveautomation.com/t/convert-numbers-to-european-format-when-querying-from-a-database/116262/1 "2026-07-03T12:47:20Z")

</div>

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?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/d/2de8775694928bb00df4fa9342546676668c79de.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/5/057de7208275cefb667adaba89bdf344eb2e7ef2.png)

---

<div class="post-metadata">

**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")

</div>

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…

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [July 4, 2026, 12:33pm UTC](https://forum.inductiveautomation.com/t/convert-numbers-to-european-format-when-querying-from-a-database/116262/3 "2026-07-04T12:33:17Z")

</div>

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!)