How To Remove Commas From Dataverse Number Field

In this Microsoft Dataverse tutorial, we will see how to remove commas from Dataverse Number field.

When I was working with the Dataverse Whole Number field, I had to get rid of a thousand separators from every number.

Remove Thousand Separator from Dataverse Number Column

The below screenshot represents a Dataverse Number field named Contact Number. The number values were displayed with separators (commas) like 993,542,662 when a user entered any numeric value into this field.

However, afterward, after removing a thousand separators from this Dataverse number field, all of the numerical values presented in a particular number format, such as 993542662 as shown below.

So let’s get started with this.

Remove thousand separators from Dataverse Number Column
Remove thousand separators from Dataverse Number Column
  • There is a Dataverse table named Job Seekers Registration List. This list has several fields along with a Number field called Contact Number.
  • As you can see in the example below, the Contact number field does not seem nice because all of the number digits are separated by a comma.
  • In order for someone to look at this Dataverse number field and understand it as a contact number field, I would like to remove all the commas from all of the contact numbers. Follow the instructions below to achieve this.
Remove commas from Dataverse number field
Remove commas from Dataverse number field
  • First, go to the Gear settings icon (from the top right corner) -> Click on the Advanced settings.
Remove commas from number field in dataverse table
Remove commas from number field in dataverse table
  • On the next page, again click on the Settings or Gear icon from the top right corner and then click on the Options settings.
How to remove commas from Dataverse number field
How to remove commas from Dataverse number field
  • Then, a Set Personal Options window will appear. Here, you can change the default display settings to personalize Microsoft Dynamics 365, and manage your email templates.
  • You can view numerous tabs in this window, including General, Synchronization, Activities, etc. In the settings window, each and every option tab has a different set of unique settings.
  • Select the Formats tab, and then click on the Customize button. Here, the Current Format field has a default value i.e. English (United States). If you want to change the format, then simply select any format from its dropdown menu.
Remove commas from number field in dataverse
Remove commas from number field in dataverse
  • The Customize Regional Options window, which is seen below, will appear once you click the Customize button. Here, you can change the format for number, currency, time, and date.
  • To change the number format, click on the Number tab.
  • Next, select the blank value from the Digit Grouping Symbol field.
  • And then select 123456789.00 from the Digit Group field as in the below image.
  • Once everything is done, click on the Apply button.
Remove thousand separator from dataverse number column
Remove thousand separator from dataverse number column
  • You may now view the modified Number Format preview under the Number Format Preview section. Finally, click on OK.
How to remove thousand separator from dataverse number column
How to remove thousand separator from dataverse number column
  • Once you will click on the OK button, it will redirect to this Set Personal Options window. Here, you can see all the Format Preview of your all settings. Click on OK.
How to remove commas from Dataverse number column
How to remove commas from Dataverse number column
  • Now go to your specific Dataverse table (Job Seekers Registration List) and then refresh it. There are no longer any separators in any number, as you can see when the dataverse table has been refreshed.
Remove commas from Dataverse number column
Remove commas from Dataverse number column

This is how we can remove commas from Dataverse Number field.

See also  11 Power Apps Gallery Conditional Formatting Examples

Additionally, you may like some more below Dataverse tutorials:

In this Microsoft Dataverse tutorial, we learned how to remove commas from Dataverse Number field.

>