# How to set the numberFormat to a different locale **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [January 27, 2025, 9:22am UTC](https://forum.inductiveautomation.com/t/how-to-set-the-numberformat-to-a-different-locale/101405 "2025-01-27T09:22:43Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Ana\_Maria\_Valdeon\_Ju](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ana\_Maria\_Valdeon\_Ju](https://forum.inductiveautomation.com/u/Ana_Maria_Valdeon_Ju)\ **Post date:** [January 27, 2025, 9:22am UTC](https://forum.inductiveautomation.com/t/how-to-set-the-numberformat-to-a-different-locale/101405/1 "2025-01-27T09:22:43Z")
Hello, I am trying to set the thousands separator to . instead of comma. I have tried putting the locale to es-ES but it continues to use the comma as separator and when I try to change the locale with a script neither does it let me change it. How could I achieve what I am trying to do? ---
**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:** [January 27, 2025, 1:30pm UTC](https://forum.inductiveautomation.com/t/how-to-set-the-numberformat-to-a-different-locale/101405/2 "2025-01-27T13:30:23Z")
You aren't the only person having difficulty. See this recent post for Swedish, Spanish and Catalan. [[BUG-3267, IGN-11874] Perspective numeric entry field decimal separator](https://forum.inductiveautomation.com/t/bug-3267-ign-11874-perspective-numeric-entry-field-decimal-separator/48866). ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [January 27, 2025, 3:27pm UTC](https://forum.inductiveautomation.com/t/how-to-set-the-numberformat-to-a-different-locale/101405/3 "2025-01-27T15:27:01Z")
It would help if you could let us know where you are having this problem (Gateway? Vision component? Perspective component? Report? If a component, any particular one?) and the version of Ignition you are running. Thanks! ---
**Author:** ![Ana\_Maria\_Valdeon\_Ju](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Ana\_Maria\_Valdeon\_Ju](https://forum.inductiveautomation.com/u/Ana_Maria_Valdeon_Ju)\ **Post date:** [January 28, 2025, 10:04am UTC](https://forum.inductiveautomation.com/t/how-to-set-the-numberformat-to-a-different-locale/101405/4 "2025-01-28T10:04:06Z")
it is a table in a perspective component ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [January 28, 2025, 4:28pm UTC](https://forum.inductiveautomation.com/t/how-to-set-the-numberformat-to-a-different-locale/101405/5 "2025-01-28T16:28:11Z")
Thanks. I've added this post to the bug ticket, which will up the priority for a fix. ---
**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:** [January 28, 2025, 7:12pm UTC](https://forum.inductiveautomation.com/t/how-to-set-the-numberformat-to-a-different-locale/101405/6 "2025-01-28T19:12:34Z")
Ana Maria - just to help with terminology: - The **Table** is a Perspective **component**. - The **Table component** is in a Perspective **view**. It may help avoid confusion in future questions. ---
**Author:** ![Gaurav.Shitole](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/gaurav.shitole/32/72050_2.png) [@Gaurav.Shitole](https://forum.inductiveautomation.com/u/Gaurav.Shitole)\ **Post date:** [January 29, 2025, 12:34am UTC](https://forum.inductiveautomation.com/t/how-to-set-the-numberformat-to-a-different-locale/101405/7 "2025-01-29T00:34:56Z")
To change the number format in a table component, set the locale to it-IT. This works perfectly. However, if some numbers still do not display correctly, add a Numeric Input Field to the same view (you can hide it if needed). This triggers an event to switch the number format for all numbers displayed on the screen. Even with this approach, ensure the locale is set to it-IT, as it seems to be the only locale that works reliably for number formatting in Ignition. ---
**Author:** ![mmadariaga](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmadariaga/32/63201_2.png) [@mmadariaga](https://forum.inductiveautomation.com/u/mmadariaga)\ **Post date:** [October 22, 2025, 11:00am UTC](https://forum.inductiveautomation.com/t/how-to-set-the-numberformat-to-a-different-locale/101405/8 "2025-10-22T11:00:12Z")
> [@Gaurav.Shitole](#): > > add a Numeric Input Field to the same view Wow thanks a lot! This worked. Anyways, is it expected to fix the table so it triggers the event without the need of the numeric entry field? I don't mind adding it with display false but it's not too clean. ---
**Author:** ![Gaurav.Shitole](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/gaurav.shitole/32/72050_2.png) [@Gaurav.Shitole](https://forum.inductiveautomation.com/u/Gaurav.Shitole)\ **Post date:** [October 26, 2025, 2:25am UTC](https://forum.inductiveautomation.com/t/how-to-set-the-numberformat-to-a-different-locale/101405/9 "2025-10-26T02:25:32Z")
Yeah they have internal bug already for this: [IGN-7305](https://forum.inductiveautomation.com/t/bug-7305-perspective-table-number-format-not-changing-according-to-the-selected-locale/70657) But don’t expect it to be fixed soon… it’s there since 2023!