Grid Column Number formats - remove Thousandth Separator
Question

We have just started to use DataGrid and have encountered a problem whereby decimals/integer values are shown with a thousandth separator. For example a column has a value of Year i.e. 2020. 

Both the Grid Column Number webblock and the Grid Column Text webblock shows the year value with a thousandth separator i.e. 2,020.

So far we haven't been able to solve this.

Hi Sam,

can you upload oml or images of code.


Thanks

Rahul


Example above demonstrates that thousandth separator is still displayed even when using grid column text

Sam Long wrote:


Example above demonstrates that thousandth separator is still displayed even when using grid column text


let me know what is the type of structure  cloumn "CR0010_YearOfAccount" is it text or integer.


Rahul Sahu wrote:

Sam Long wrote:


Example above demonstrates that thousandth separator is still displayed even when using grid column text


let me know what is the type of structure  cloumn "CR0010_YearOfAccount" is it text or integer.


It is integer

I have also faced the same issue? How can we resolve this issue? Any idea?

I also have face the same issue too. Can anyone help on this?

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.