Excel guide
How to Convert Million to Crore in Excel: Formula + Steps
To convert million to crore in Excel, multiply the cell value by 0.1 using the formula =A1*0.1.
By Sophia
1 million equals 0.1 crore, so multiplying by 0.1 gives the crore equivalent. This page covers 3 methods: the formula, Paste Special, and a custom number format for crore-style display.
The Excel Formula to Convert Million to Crore
=A1*0.1
=A1/10
Both formulas divide the million value by 10 to give crores, so either one works.
If A1 holds 50 million, =A1*0.1 returns 5 crore.
Step-by-Step: Convert a Single Cell
- 1 Enter your value in millions in cell A1, for example 50.
- 2 Click on cell B1, where you want the crore result.
- 3 Type the formula =A1*0.1
- 4 Press Enter. Cell B1 displays the crore value, which is 5 for 50 million.
Step-by-Step: Convert an Entire Column
- 1 Enter all million values in column A, for example A1:A20.
- 2 Click on cell B1.
- 3 Type the formula =A1*0.1
- 4 Copy cell B1, then select B2:B20 and paste. Every crore value populates automatically.
For large datasets, enter =A1:A20*0.1 as an array formula using Ctrl+Shift+Enter in Excel 2019 and earlier, or just Enter in Excel 365 and 2021 with dynamic arrays.
Full guide: Million to Lakh Crore Calculator — See any million figure in lakh and crore at the same time.
Method 2 — Using Paste Special to Multiply by 0.1
- 1 Enter 0.1 in any blank cell and copy it.
- 2 Select the range of million values you want to convert.
- 3 Right-click, choose Paste Special, then select Multiply under Operation.
- 4 Click OK. Excel multiplies every selected cell by 0.1 in place.
- 5 Delete the helper cell containing 0.1.
This method overwrites the original values. Use it only on a copy of your data.
Method 3 — Custom Number Format for Crore Display
Custom number formats display numbers differently without changing the underlying value.
Excel Custom Format for Indian Number System
- 1 Select the cells to format.
- 2 Press Ctrl+1 to open Format Cells.
- 3 Click Custom under Category.
- 4 Enter the format code ##\,##\,##0.00
- 5 Click OK. Numbers now display with Indian comma grouping.
This changes the display only. The cell still stores the original value in millions, so divide by 10 separately to get the actual crore value.
How to Convert Crore to Million in Excel
=A1*10
If A1 holds 5 crore, =A1*10 returns 50 million.
Bonus: Convert Million to Both Lakh and Crore in One Sheet
Set up 3 columns: column A for the million input, column B for the crore result with =A1*0.1, and column C for the lakh result with =A1*10.
| A — Million | B — Crore (=A1*0.1) | C — Lakh (=A1*10) |
|---|---|---|
| 10 | 1 | 100 |
| 25 | 2.5 | 250 |
| 100 | 10 | 1,000 |
Conclusion
To convert million to crore in Excel, multiply by 0.1 with =A1*0.1, and reverse it with =A1*10.
Single-cell formulas and dynamic array formulas cover almost every case. To check a figure without a spreadsheet see the Million to Crore Calculator, and for lakh and crore together see the Million to Lakh Crore Calculator.
Quick answers
Frequently Asked Questions
What is the Excel formula to convert million to crore?
The Excel formula to convert million to crore is =A1*0.1. The formula =A1/10 returns the same result, because dividing by ten and multiplying by 0.1 are the same operation.
How do I apply the formula to an entire column?
Copy =A1*0.1 down the column with the fill handle, or enter the dynamic array formula =A1:A100*0.1 once in Excel 365 and 2021. Both fill every row from a single formula.
Can I display numbers in crore format in Excel without a formula?
Yes. Use a Custom Number Format with the code ##\,##\,##0.00 for Indian comma grouping. This changes the display only, so divide by 10 separately to get the actual crore value.
What is the formula to convert crore to million in Excel?
The formula to convert crore to million in Excel is =A1*10. If A1 holds 5 crore, the formula returns 50 million.
How do I convert million to lakh in Excel?
Multiply the million cell by 10 using =A1*10. One million equals ten lakh, so the same multiplier converts crore to million as well.
Does Excel have an Indian number format?
No, Excel has no built-in Indian number format. Use a Custom Number Format with the code ##\,##\,##0.00, or set your Windows region to English (India) so the lakh and crore grouping applies automatically.
How do I convert million to crore in Excel for large datasets?
Use the dynamic array formula =A1:A1000*0.1 in Excel 365 or 2021, which fills the whole range from one cell. For older versions use Paste Special and multiply the range by 0.1 in place.