Get Free Trial
Get Free Trial

Issue in Number Formatting

Naveen asked on September 12, 2019

Amount display format – Currently amounts shown in Millions by default. How to change the amount from Millions to Crores or Lakhs(based on requirement)?
Amount display format means, currently it showing amount as in this format 743,025,039. 
I need to change in Indian currency format, like 74,30,25,039 (Seventy Four Crore Thirty Lakh
Twenty Five Thousand And Thirty Nine Rupees). Can you please help me in this, as I searched in
documentation and I cant find any format for Indian currency(thousandsSeparators).
 
Regards,
Naveenkumar

1 answer

Public
Vera Didenko Flexmonster September 12, 2019

Hello, 
 
Thank you for your question.
 
Could you please specify what you mean by amount display format?
 
As we understand, 1 Crores denotes to ten million (10,000,000) and 1 Lakhs denotes to one hundred thousand (100,000).
If you wish to format the cell data on the grid, we kindly suggest converting the millions to the equivalent in Crores or Lakhs via the customizeCell() API call ( please see: https://www.flexmonster.com/api/customizecell/ ).
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/vnwuhab2/
 
Could you please let us know if this is the result you are looking for?
 
You are welcome to contact us in case of questions.
 
Best Regards,
Vera

Please login or Register to Submit Answer