# How to Change Lakhs to Millions in Excel in Windows 10: A Step-by-Step Guide

Changing Lakhs to Millions in Excel on Windows 10

If you need to convert numbers from lakhs to millions in Excel on your Windows 10 computer, it’s a pretty straightforward process. Essentially, you’ll be dividing each value by 10 to shift the number from the lakh unit to the million unit. This guide will walk you through each step so that you can accomplish this task quickly and efficiently.

## How to Change Lakhs to Millions in Excel on Windows 10

In this section, you’ll learn how to change numbers from lakhs to millions. Following these steps will allow you to perform the conversion without any hassle.

### Step 1: Open Your Excel File

Open the Excel file that contains the numbers you want to convert.

Double-click the Excel file on your computer, or open Excel and navigate to the file. Make sure the file is loaded and ready.

### Step 2: Select the Cells

Select the cells containing the numbers you want to convert from lakhs to millions.

Click and drag your mouse over the cells, or hold down the Ctrl key and click each cell individually.

### Step 3: Create a New Column

Insert a new column next to your original data to display the converted numbers.

Right-click on the column header where you want the new column, and choose "Insert" from the context menu.

### Step 4: Enter the Conversion Formula

Type the formula to divide the numbers by 10 in the first cell of the new column.

The formula should look like this: `=A1/10` (assuming A1 is your first cell with a number in lakhs).

### Step 5: Copy the Formula

Copy the formula down the entire column to convert all numbers.

Click the small square at the bottom-right corner of the cell with the formula and drag it down to fill the column.

### Step 6: Format the New Column

Format the new column to display the numbers as millions.

Right-click the header of the new column, choose "Format Cells," select "Number," and set the desired decimal places.

After completing these actions, all the numbers that were originally in lakhs will be displayed in millions in the new column you’ve created.

## Tips for Changing Lakhs to Millions in Excel on Windows 10

1. Double-Check Your Data: Always double-check the numbers before and after conversion to ensure accuracy.
2. Use Absolute References: When copying formulas, use absolute references if the formula needs to point to a specific cell constantly.
3. Label Your Columns: Clearly label your new column to indicate that the values are in millions.
4. Save Your Work: Frequently save your Excel file to avoid losing any data.
5. Automate with Macros: If you need to do this frequently, consider using an Excel macro to automate the process.

### What is a lakh?

A lakh is a unit in the Indian numbering system equal to 100,000.

### Why do I need to convert lakhs to millions?

Converting lakhs to millions can make data easier to understand, especially for audiences more familiar with the Western numbering system.

### Can I convert lakhs to millions without creating a new column?

Yes, but creating a new column keeps your original data intact for reference and accuracy.

### Will the formula work for large datasets?

Yes, the formula will work regardless of dataset size, as long as your Excel version supports large datasets.

### Can I format the numbers in millions using shortcuts?

Yes, you can use the "Format Cells" window or keyboard shortcuts like Ctrl+1 to quickly format cells.