How to get Numeric Currency from billions & millions to lacs & crores in Excel?
Right click cell.
Go to Format Menu
In Category click Text
Then Click Custom
Then paste this below 2 codes and u will be getting nos. in lacs
Without decimal :
99,99,99,999 [>=10000000]#","##","##","###;[>=100000]#","##","###;#,###
With decimal :
99,99,99,999.00 [>=10000000]#","##","##","##0.00;[>=100000]#","##","##0.00;#,##0.00
And now you get amounts in Indian currency format.
Thx
XYZ
Right click cell.
Go to Format Menu
In Category click Text
Then Click Custom
Then paste this below 2 codes and u will be getting nos. in lacs
Without decimal :
99,99,99,999 [>=10000000]#","##","##","###;[>=100000]#","##","###;#,###
With decimal :
99,99,99,999.00 [>=10000000]#","##","##","##0.00;[>=100000]#","##","##0.00;#,##0.00
And now you get amounts in Indian currency format.
Thx
XYZ