i have an interactive report in my apex page with numbers (money) in it, the default money format is U.S which is like this :
###,###,###,###.##
what i need is this :
### ### ### ###,##
is there a way to do so in HTML or in CSS or JAVASCRIPT
How about
or
const number = 10000.50
console.log(new Intl.NumberFormat('fr-FR',{minimumFractionDigits:2}).format(number))
console.log(number.toLocaleString('fr-Fr', {
style: 'currency',
currency: 'EUR',
minimumFractionDigits: 2
}));
The display format in an apex report is determined by 2 parameters:
In oracle this is determined at session level. You want , as decimal and space as group separator. To change this for your database session run the following statement.
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ', ';
EXECUTE IMMEDIATE q'!ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ', '!';
EXECUTE IMMEDIATE statement aboveThe Number Format Models documentation might give you some clues here: 9is a NUMBER, D is the decimal separator, G is the group separator. So you're looking for 999G999G999G999D99
SELECT TO_CHAR(9866166747393/100,'999G999G999G999D99') from dual;
98 661 667 473,93
Set this as Appearance > Format Mask of the column in your interactive report.