Thousands Separator display format is not grouping digits correctly as per US Standards

[Anonymous]

Hi All,

The thound separator is not grouping the digits correctly to show the correct format of numeric value as per the US standards in my report. In stead of $11,06,185 , it should display as $1,106,185. Even I have the Regional settings as English(United States). Also tried to change the type to Locale "en-US". That didnt work. Kindly suggest whether possible to customize the commas position by the help of comma separator.

Thanks In Advance,

Tanisha

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Please try to right-click on the column name and select Change Type, then Using Locale in the contextual menus.

Choose a Data Type and Locale from the Change Type with Locale window. This window provides a sample view of how the numbers will display based on the selected locale which is beneficial. Click on the OK button to implement the changes.

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.