1 Reply Latest reply on Apr 9, 2018 9:59 AM by Deepak Rai

    Convert Numbers in Lakhs

    Sa Ss

      Hi,

       

      I have to convert 1 amount 100,531,563 to Lakhs but when i go to format and custom format it shows 100.53 L (Because if you see that figure it looks like 100.53 Lakhs which is wrong actual amount is 10 Crore and 05 Lakhs). My expectation is 10.053 L. Can any one help me out