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.

mvp_badge
MVP

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

mvp_badge
MVP

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?

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