Format excel column to display Rupee in Lakhs




If your country’s currency system is in Lakhs and Crores, and not in Millions and Billions, this is what you need to do.

  1. Select all the cells where you want the numbers to then display in Lakhs and Crores (let’s say entire D column).
  2. Right-click and go to ‘Format cells’ (shortcut to go to format cells is Ctrl + 1).

 

3. Select ‘Custom’ and in the ‘Type’ box, type this and click ok

[>=10000000] [$?-ta-IN] ##\,##\,##\,##0;[>=100000] [$?-ta-IN] ##\,##\,##0;##,##0

 




Reference




Private

This area is only for registered user. Please register.