Hi Team,
I am looking for a code using which the numbers should have commas as per indian standard but upto lakh value
e.g. 21234567890.50 should be visible as 2123,45,67,890.00 i.e. comma should be restricted upto lakh
similarly, if the value is negative it should be visible with brackets
like (2123,45,67,890.50).
I tried various options but all works in silos but not as a single condition.
Please suggest the code.
thanks
I am looking for a code using which the numbers should have commas as per indian standard but upto lakh value
e.g. 21234567890.50 should be visible as 2123,45,67,890.00 i.e. comma should be restricted upto lakh
VALUE | POSITIVE VALUE |
20.00 | 20.00 |
100.42 | 100.42 |
5100.42 | 5,100.42 |
25100.42 | 25,100.42 |
225100.42 | 2,25,100.42 |
1025100.00 | 10,25,100.00 |
51025100.42 | 5,10,25,100.42 |
29401025100.42 | 2940,10,25,100.42 |
similarly, if the value is negative it should be visible with brackets
like (2123,45,67,890.50).
I tried various options but all works in silos but not as a single condition.
Please suggest the code.
thanks