I use Google sheet to keep track of my investment portfolio. One bad thing with Google sheet is that it does not provide Lakh format out of the box, however adding support is straight forward.
To add support for Lakh and Crore to Google Sheet, navigate to Format -> Number -> More Formats -> Custom Number Format and enter below custom number format as per your requirement.
To show positive and negative INR/Rs. up to Lakh
[>99999][$₹]##\,##\,##0.00;[<-99999][$₹]##\,##\,##0.00;[$₹]##\,##0.00
To add support for positive lakhs and crores
[>9999999][$₹]##\,##\,##\,##0.00;[>99999][$₹]##\,##\,##0.00;[$₹]##,##0.00
Add support for negative lakhs and crores
[<-9999999][$₹]##\,##\,##\,##0.00;[<-99999][$₹]##\,##\,##0.00;[$₹]##,##0.00
For Microsoft excel, add the above format at
Format -> Cells -> Custom -> [Custom text box]
Below screenshot demonstrates above custom format in use:
Tags: How to add Lakh and Crores support to Google Sheet/Microsoft Excel
No comments:
Post a Comment