Microsoft Dynamics CRM (Archived)

How to Remove commas from whole number field .

(0) Share

Report

Posted on by Community Member

HI,

I am creating new field "year of graduation". data type "Whole number'. I change the number format also.

but it again shows commas . So how can i remove commas from whole number field.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

ScottDurow 21 on at

Like (1)

Report

RE: How to Remove commas from whole number field .

Unfortunately there isn't any way of formatting an integer outside of the user's formatting settings. So if you wanted this number without commas then all number would have to be without them.

I suggest you create a text field and add some javascript validation to it. If you need it in report criteria etc. then you could create a backing field of numeric type that gets set by the text value.

Hope this helps,

Scott

Was this reply helpful? Yes No
Solutions 5 on at

Like (0)

Report

RE: How to Remove commas from whole number field .

Hi Viswanadh ..Go to Settings >Click on System Settings>Click on Format>Select the country Currency>Click on Customize ... I Think It helps.

Was this reply helpful? Yes No
Suggested answer

shivaram 3,315 on at

Like (1)

Report

RE: How to Remove commas from whole number field .

Hi Viswanath,

Try following one.

Go to settings-->Formats-->Customize-->Change the Digit Group Format.

Hope this helps you.

Thank you,

Shiva.

Was this reply helpful? Yes No
Suggested answer

Jharana Baliyar Singh 2,667 on at

Like (0)

Report

RE: How to Remove commas from whole number field .

Hi Viswa,

If you want to do this for all forms then go for Options->Formats tab->Digit Group.It will change the format for each & every fields present in the CRM form,but it will affect only for new users, but won't reflect for existing users for that you have to change user settings.

Otherwise, if u want to go for specific field then you have to create a text field & write javascript code for that .

Please have a look in to below links:

community.dynamics.com/.../151926

stackoverflow.com/.../crm-2013-to-remove-comma-from-whole-number-field

https://ashwaniashwin.wordpress.com/2013/02/17/whole-number-format-in-dynamics-crm-2011/

Thanks,

Jharana

Was this reply helpful? Yes No
Suggested answer

JayeshAC 1,157 on at

Like (0)

Report

RE: How to Remove commas from whole number field .

Hi Viswanadh,

you need to change the format inside the personal settings.

Options>>Format>>Click Customize Personal Setting>>Numbers

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Vipin J 1,603 on at

Like (0)

Report

RE: How to Remove commas from whole number field .

I created a web-resource as I was restricted not to changed the personalization and not to create any other text field.

Here is code and detail explanation

https://vjcity.blogspot.com/2020/10/remove-comma-from-number-fields-in.html

Was this reply helpful? Yes No