How to Display Numbers in Crores Using Custom Formatting in MS Excel

Using custom formatting is an efficient way to display numbers in crores directly in Excel.

Here are the detailed steps to achieve this:

Open Excel and Select the Cells:
- Open your Excel sheet containing the numbers you want to convert.
- Select the cells that contain the numbers you want to format. For example, if your numbers are in Column A, select all the relevant cells in Column A.
Open the Format Cells Dialog:
- Click on the "Home" tab in the Excel ribbon.
- In the "Number" group, click on the small arrow in the bottom right corner to open the "Format Cells" dialog.
- Alternatively, you can right-click on the selected cells and choose "Format Cells..." from the context menu.
Apply Custom Number Format:

In the "Format Cells" dialog, go to the "Number" tab.
Select "Custom" from the list on the left.
In the "Type" field under "Custom", enter the following format code:
```
0.00,, "crores"
```
Click "OK" to apply the custom format.

0.00: This part of the format code ensures that the number is displayed with two decimal places.
,,: Each comma (,) in the format code divides the number by 1,000. Two commas divide the number by 1,000,000 (which is 10^6), effectively converting the number to lakhs. Since 1 crore equals 10 million, using two commas converts the number to crores.
"crores": This text is added after the number to indicate the unit.

If your original numbers are:

After applying the custom number format, the cells will display:

This custom format only changes the display of the numbers. The underlying values in the cells remain unchanged.
You can adjust the number of decimal places by modifying the format code (e.g., 0.0,, "crores" for one decimal place or 0,,, "crores" for no decimal places).

By following these steps, you can easily convert and display numbers in crores in Excel without the need for coding.

ORA-01075 you are currently logged on