Grid Column Number formats - remove Thousandth Separator

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