How to add comma in number field

[Narsha Bac]

Is it possible to populate a comma to a number field automatically? To be able to separate the digits?

[Nic Brough -Adaptavist- · Accepted solution]

Number fields only hold raw numbers, but their display is determined by your language and region settings.

If I enter 1000000 into a numeric field, it displays as 1,000,000 for me, because English uses "," as the three digit separator.  The field still only holds 1000000.

If your number fields are actually strings, then you'll need to edit them to add separators.

[Narsha Bac]

Hi Nic,

I changed the region settings and it worked.

Thanks!

[Dan Breyen]

HI Narsha, there isn't specifics in your question regarding formatting, so I might be stretching a little.  Out of the box, it looks like you can't format it directly, but with a little automation, it appears it can be done. I found this community article on formatting: Number-field-formatting 

I hope that answers your question.

[Narsha Bac]

Hi Dan, 

Sorry for this.

I created some custom field of type numeric. But, I want on the creation screen itself to be able to format this. For example, when entering a value like this '2152', it should appear like this: '2,152' or '2.152'. 

From the article I assume they are using automation rule to format it? But in my case I want this to happen on the creation screen itself - while creating the issue, which I think is quite challenging to achieve on the creation screen.

Can you please help me on this?

Thanks.