# Floating-point digit separator on easy chart

**URL:** <https://forum.inductiveautomation.com/t/floating-point-digit-separator-on-easy-chart/91666>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [June 11, 2024, 5:44am UTC](https://forum.inductiveautomation.com/t/floating-point-digit-separator-on-easy-chart/91666 "2024-06-11T05:44:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![June\_Zhu](https://avatars.discourse-cdn.com/v4/letter/j/b77776/32.png) [@June\_Zhu](https://forum.inductiveautomation.com/u/June_Zhu)\
**Post date:** [June 11, 2024, 5:44am UTC](https://forum.inductiveautomation.com/t/floating-point-digit-separator-on-easy-chart/91666/1 "2024-06-11T05:44:35Z")

</div>

I created a SQL table with a Y\_Axes\_Limit (format: float(24,0)) feild inside, Windows 10 OS, Ignition v 8.1.36. for example:

Name, Y\_Axes\_Limit  
pen1, 10000  
pen2, 30  
pen3, 200

when I used a Easy Chart to read this Y\_Axes\_Limit feild as its Y-axes of that Easy Chart, when in English language it will work perfect, however when it work in Turkey Language,  
it will display 100.000(dot as a thousandth separator) and 300 and 2.000(dot as a thousandth seperator)  
All Y axes values are 10 TIMES (!!!) the original value in the database. This causes all preset Y-axes to be incorrect in Turkey language

when I read those feilds from the same SQL table into HMI or a Power Table, it will display correctly in whatever language, displaying as: 10000, 30, 200

not sure what caused my problem, It seems that the easy chart component is not parsing the numbers correctly. I confirm that my Window 10 system is set to Decimal symbal (dot) and Digit grouping symbol (comma).

any help will be very appreciated.

 ![1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/2/82523a68d574073a15abba509dc7475dd2532ff6.jpeg)

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [June 11, 2024, 7:10am UTC](https://forum.inductiveautomation.com/t/floating-point-digit-separator-on-easy-chart/91666/2 "2024-06-11T07:10:49Z")

</div>

In the Axes dataset, there is a number format column:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/7/470a97a0f2aa342a78fd972721690a7ee9236af1.png)

The default Easy Chart number formatting can be overridden here. A simple # symbol in this column will eliminate the decimal/comma from the number.

Here is some usefull information that will help with number formatting:  
[numberFormat | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/expression-functions/string/numberFormat)