I am having the number like 123456
and i want to format the number like 1,23,456
how can i achieve this using javascript or jquery.
I am working of oracle apex classic report with text boxes.
text boxes contain the numeric values.
upon page load all numeric column should be in format
select
"EMPNO",
"ENAME",
"JOB",
"MGR",
"HIREDATE",
"SAL", ---NUMERIC --if number is 123456 then on page load it should be 1,23,456
"COMM",--NUMERIC --if number is 123456 then on page load it should be 1,23,456
"DEPTNO"
from emp;
I am trying to do the formating from report attribute->column attribute->Number / Date Format = 999G999G999G999G990 but its not working.
As i used many CSS method for these textboxes which overwriting the existing functionality (like number formating)
thanks