Skip to main content

Hi Team,

I have a currency column that i have entered value is $12000.

But it shaving as 12.000,00

How it fix it.

can you show me the currency column settings please?


Hi Cassy,

Please find the currency column settings for your kind reference

207298_pastedImage_1.png


In your column settings, it is showing dots instead commas both in Max value and Currency format. Any idea why?

it should be like this.

207319_pastedImage_1.png

207320_pastedImage_2.png


Hi Lakshmi, 

thousend separator is related to regional settings of the site, some of them have dots as thousand separator and comma as decimal separator..

Giacomo


Hi,

in your settings, you have set to have two decimal places, that's why you have 12.000,00 (the thousand separator is a default for number/currency field)

Giacomo


Go to your Site settings -- Regional settings-- set locale drop down value to English (United States).

207321_pastedImage_2.png


Reply