Answered

Deactivate or Remove Separator in Whole Number

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys,

I have a field using whole number. This field automatically makes a thousand-separator for example 2020 become 2,020. Is there a way to deactivate the separator? thanks, guys.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @Anonymous,
Yes you can update those default settings. Note that users can change their personal preferences as well. You can update by:
Clicking the gear icon on the top right
Click "Advanced Settings" then in the "Settings" menu in the top navigation bar, select "Administration" and then pick "System Settings"
On the popup window select the "Format tab"
You can select a default format based on the region/country or click the Customize button to configure individually.
For personal settings, select "Personalization Settings" after clicking the gear icon on the top right and then on the popup select the "Format tab".
For more info: https://docs.microsoft.com/en-us/power-platform/admin/system-settings-dialog-box-formats-tab
Hope this helps!

Was this reply helpful? Yes No
Verified answer

David Jennaway 716 on at

Like (1)

Report
Copy link

Link copied!

To add to the previous post, this setting necessarily applies to all whole number fields. If you just want to change the display format for one field, your only realistic option is to recreate the field as a text field

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for the answers it is really helpful. 😀

Was this reply helpful? Yes No