$currency format issue

  • 6 September 2017
  • 6 replies
  • 6 views

Badge +4

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.


6 replies

Badge +16

can you show me the currency column settings please?

Badge +4

Hi Cassy,

Please find the currency column settings for your kind reference

207298_pastedImage_1.png

Badge +9

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

Userlevel 4
Badge +11

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

Userlevel 4
Badge +11

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

Badge +4

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

207321_pastedImage_2.png

Reply