Excel VBA Consultant - Want to display Millions in Lakhs and Crores ?

Here's a tip to display numbers in lakhs and crores in Excel by our Excel VBA Consultant.

Steps:

• Right Click on the cell
• Click on Format cells
• Go to Custom Category

Type the below format

For Lakhs and crores (+ve) with decimals

[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

For Lakhs and crores (-ve) with decimals

[<-9999999](##\,##\,##\,##0.00);[<-99999](##\,##\,##0.00);##,##0.00

For Lakhs and crores (+ve) without decimals

[>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0.00;##,##0.00

For Lakhs and crores (-ve) without decimals

[<-9999999](##\,##\,##\,##0);[<-99999](##\,##\,##0.00);##,##0.00

Hope you enjoyed this tip !!!

Happy Excelling !!!

For more information contact our Excel VBA Consultant at 646.583.0001