Skip to main content
Nintex Community Menu Bar

$currency format issue

  • September 6, 2017
  • 6 replies
  • 20 views

Forum|alt.badge.img+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

Forum|alt.badge.img+16

can you show me the currency column settings please?


Forum|alt.badge.img+4

Hi Cassy,

Please find the currency column settings for your kind reference

207298_pastedImage_1.png


Forum|alt.badge.img+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


Forum|alt.badge.img+11
  • Nintex Partner
  • September 6, 2017

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


Forum|alt.badge.img+11
  • Nintex Partner
  • September 6, 2017

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


Forum|alt.badge.img+4

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

207321_pastedImage_2.png