Skip to content

Instantly share code, notes, and snippets.

@anishkny

anishkny/gist:33d87ca4a754e5653cc9919fc2831c42

Created January 17, 2021 23:30
Show Gist options
  • Save anishkny/33d87ca4a754e5653cc9919fc2831c42 to your computer and use it in GitHub Desktop.
Save anishkny/33d87ca4a754e5653cc9919fc2831c42 to your computer and use it in GitHub Desktop.
Download ZIP
Displaying Lakhs and Crores in Google Sheets
Raw
gistfile1.txt
[$₹][>9999999]##\,##\,##\,##0.00;[$₹][>99999]##\,##\,##0.00;[$₹]##,##0.00
Google Sheets : Format -> Number -> More Formats -> Custom Number Format
Excel : Format -> Cells -> Custom -> [Custom text box]
Source: https://stackoverflow.com/a/34690816/8901261
@hiteshsahu
Copy link

July 2023: Another option is to use formula on cell value:

=CONCATENATE("₹", 
 if(abs(B3)<100000,B3,
  if(abs(B3) <10000000,text(B3/100000,"#.0")&" Lakh",
   if(abs(B3)<=1000000000,text(B3/10000000,"#.0")& "Crore", 
      text(B3/10000000,"#.0")& "Crore"))

enter image description here

enter image description here

enter image description here

enter image description here

You can modify formula to extend it to arab, kharab etc.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment