1.5 Number Formats: Rupees in Indian Style and Dates
Home › Number group (or Ctrl + 1 › Number tab) controls how numbers appear.
| Format | Shows 125000.5 as | Shortcut |
|---|---|---|
| General | 125000.5 | Ctrl + Shift + ~ |
| Number (2 decimals, separator) | 1,25,000.50 or 125,000.50* | Ctrl + Shift + ! |
| Currency ₹ | ₹1,25,000.50* | Ctrl + Shift + $ uses your system currency |
| Percentage | 12500050% | Ctrl + Shift + % |
| Short Date | depends on system (see below) | Ctrl + Shift + # |
* Whether you see lakh grouping (1,25,000) or thousand grouping (125,000) depends on the Windows regional setting (English (India) gives 1,25,000). This may vary by version and settings.
Rupee in Indian comma style on any computer. Use this custom format (explained in 1.6):
[>=10000000]₹##\,##\,##\,##0;[>=100000]₹##\,##\,##0;₹##,##0
| Value | Displayed |
|---|---|
| 950 | ₹950 |
| 45000 | ₹45,000 |
| 125000 | ₹1,25,000 |
| 23450000 | ₹2,34,50,000 |
This code handles positive numbers (the usual case for sales). If your PC is already set to English (India), the simple format ₹#,##,##0 (or ₹#,##0) also shows lakh grouping.
Dates. Excel stores a date as a serial number (1 = 01-01-1900) and a time as a fraction of a day (0.5 = 12:00 PM). To show dd-mm-yyyy: Ctrl + 1 › Number › Custom › type dd-mm-yyyy. For date with IST time: dd-mm-yyyy hh:mm.
Steps in Excel
- Select the Amount column › Ctrl + 1 › Number tab › Custom › paste the Indian-style code above › OK.
- Select Order Date › Ctrl + 1 › Custom ›
dd-mm-yyyy› OK. - To see the stored value, temporarily switch to General: 14-03-2026 becomes 46095.
Ravindra Bagale's Tip
Friends, many students type "₹" or "Rs." themselves in an amount – then Excel treats it as text and SUM gives 0. Type only the number in the cell, and show the ₹ symbol with a number format. In the same way, don't type a date with dots like "14.03.2026"; apply the dd-mm-yyyy format.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students amount मध्ये "₹" किंवा "Rs." स्वतः type करतात – मग Excel ला तो text वाटतो आणि SUM 0 देतो. Cell मध्ये फक्त number type करा, आणि ₹ symbol number format ने दाखवा. तसंच date "14.03.2026" अशी dots ने type करू नका; dd-mm-yyyy format लावा.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students amount में "₹" या "Rs." खुद type कर देते हैं – फिर Excel उसे text मानता है और SUM 0 देता है. Cell में सिर्फ़ number type करो, और ₹ symbol number format से दिखाओ. इसी तरह date को "14.03.2026" जैसे dots से type मत करो; dd-mm-yyyy format लगाओ.
Practice task
Enter 950, 45000, 125000 and 23450000 in a column and apply the Indian rupee custom format. Enter today's date with Ctrl + ;, show it as dd-mm-yyyy, then as dddd (day name).