Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

105
Views
use a custom number format for money in HTML

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

about 4 years ago · Juan Pablo Isaza
2 answers
Answer question

0

How about

Intl.NumberFormat

or

toLocaleString

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 
}));

about 4 years ago · Juan Pablo Isaza Report

0

The display format in an apex report is determined by 2 parameters:

  • Appearance > Format Mask of the column in your interactive report
  • Decimal and Group separator set in the database session.
Decimal and group separator

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 = ', ';
  • To change this for your entire application, set the following in Shared Components > Security > Database Session > Initialization PL/SQL Code
EXECUTE IMMEDIATE q'!ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ', '!';
  • To just set this for the page you have your report on you can either use an application process (with condition Current Page is contained within expression) = "your page" or a before header process to execute the EXECUTE IMMEDIATE statement above
Format Mask

The 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.

about 4 years ago · Juan Pablo Isaza Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!