Must-Know Excel Formatting Tricks for Indian Users by Raj Singh

Make your Excel sheets India-friendly! Learn how to format numbers in lakhs and crores, use Indian date formats, and apply custom data validation—all tailored for Indian users and businesses.

Formula 1: Indian Currency Number Formatting:

[>=10000000]##\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

What it does:
This custom number format displays numbers in Indian numbering system (crores, lakhs, thousands), such as:

• 123456789 → 12,34,56,789
• 500000 → 5,00,000
• 9999 → 9,999

You can apply it via:

1. Select cells ➝ Right-click ➝ Format Cells ➝ Number ➝ Custom.
2. Paste the format above.

I hope you found these Excel tips useful for working with Indian currency, dates, and number formats. These little tweaks can make a big difference, especially when you’re dealing with reports, invoices, or any data meant for Indian audiences.

✅ Before you go:

• Bookmark this page so you can refer back to it whenever you need.
• Try out these formats in your own Excel files—be it for accounting, sales reports, or student results.
• Share this post with your teammates or anyone else who works with Excel in an Indian context. I’m sure they’ll appreciate it!

If you’ve got any cool tricks of your own, feel free to share them with me—I’d love to include them in future posts!