Thousand separator and decimals separator with ROUND


I have a calculated field with the following code:

FORMAT(ROUND(fieldname2*fieldname5*1.33515, 0.1), {groupingsymbol:’.’})

I want:
thousands separator = “.”
decimals separator = “,”

So e.g. one thousand and twenty cents be: 1.000,2 (rather than the US customs of thousands separator and decimals separator which is “,” and “.”, respectively.

How do I do that?


This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer