# Number formating in table

**URL:** <https://forum.inductiveautomation.com/t/number-formating-in-table/103509>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [March 11, 2025, 1:56pm UTC](https://forum.inductiveautomation.com/t/number-formating-in-table/103509 "2025-03-11T13:56:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thomas\_Tornblom](https://avatars.discourse-cdn.com/v4/letter/t/c67d28/32.png) [@Thomas\_Tornblom](https://forum.inductiveautomation.com/u/Thomas_Tornblom)\
**Post date:** [March 11, 2025, 1:56pm UTC](https://forum.inductiveautomation.com/t/number-formating-in-table/103509/1 "2025-03-11T13:56:05Z")

</div>

I have a problem I can't find a good solution for. I have some tables that get data from a database with a named query. The data in the database is in Swedish format but in Perspective the number for TRANSPORT is presented in US format.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/7/470174fb6dd1a5397907e0f3ad022b92c471caa4.png)  
How do I change this? I can't do it in the property editor under column and number format since this is not changing the format. The named query returns the data in US format and I use a script transfrorm in the data binding for the colors on the rows.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/6/c63b7824674c7d0ec1d74e93790b6aac31497fea.png)

---

<div class="post-metadata">

**Author:** ![Jiri\_Pise](https://avatars.discourse-cdn.com/v4/letter/j/58956e/32.png) [@Jiri\_Pise](https://forum.inductiveautomation.com/u/Jiri_Pise)\
**Post date:** [March 11, 2025, 2:24pm UTC](https://forum.inductiveautomation.com/t/number-formating-in-table/103509/2 "2025-03-11T14:24:17Z")

</div>

I'm running a version **8.1.35** and there is a bug with loading the locale from the browser.

**Solution that works for me:**  
Place a numeric entry field somewhere on the same view. (you can give it visible false if you dont want to have it there).

---

<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:** [March 11, 2025, 2:24pm UTC](https://forum.inductiveautomation.com/t/number-formating-in-table/103509/3 "2025-03-11T14:24:38Z")

</div>

Related: [[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).