How to Convert Numbers in Crores in Excel Without Coding

Converting numbers in crores in Excel is a straightforward process that can be achieved through simple methods without needing to write any code. This article will guide you through using custom number formatting and regional settings to display these large numbers effectively.

Using Custom Number Formatting

One of the most effective ways to display numbers in crores in Excel is by using custom number formatting. Here’s how you can do it:

Step-by-Step Guide

Select the cells containing the numbers you want to convert. Right-click on the selected cells and choose Format Cells. Go to the Number tab and select Custom from the Category list. In the Type field, enter the following custom number format: [10000000]0.00[100000] 0.000.00. Click OK.

This custom number format will display numbers in crores with two decimal places. For example, 1 crore will be displayed as 1,00,00,000.00.

Using Regional Settings

Another method to display numbers in crores involves changing the regional settings in Excel. Here’s how to do it:

Go to the Control Panel on your computer. Select Regional Settings. Apply the changes and close the dialog box.

By changing the regional settings, Excel will automatically display numbers in crores according to the Indian grouping format.

It’s important to note that these methods will only change the display format of the numbers in crores. The actual values in the cells will remain the same. If you need to perform calculations or use the converted values in formulas, you may need to use additional functions or formulas.

Additional Methods for Conversion

To convert numbers to crore:

Select the cells that hold the numbers you want to multiply by 100 to get crores. Select the cells to be converted. Enter 1 crore (1,00,00,000) in a blank cell. Copy that cell. Select the cells to be converted and use the Paste Special ribbon item. Choose the Divide option and click OK.

To display numbers in crore:

Select the cells containing the numbers you want to format. Click on the Number tab in the ribbon. Select the Custom format. Enter the type: 0. This will display the numbers in crore format but without any decimal places. To display numbers in crore with two decimal places, like a financial report but without changing their underlying values: Enter the type: .00 (to maintain two decimal places). To implement the three commas and the multiplication, use the custom format: .00CTRL J. Here, the three commas are equivalent to dividing by 100 crore, and the CTRL J holds the Control key down and types J in the middle of the number format, inserting a line feed before the decimal point. To apply this format, enter: .00CTRL J and turn Wrap Text on but do not change the row height.

Learn More

For more information on displaying Lakhs and Crores in Excel or how to show Indian currency format in Excel, you can refer to the following resources:

How to Display Lakhs and Crores in Excel How to Show Indian Currency Format in Excel How to Show Indian Number Formats in Excel Format Numbers as Currency in Excel for the Web - Microsoft Support

By following the methods discussed in this article, you can easily convert numbers in crores in Excel without writing any code.