# Entering Data as Thousands in Excel

When it comes to working with large numbers in Excel, it can be difficult to read and interpret data that is displayed in full. This is where entering data as thousands in Excel can be incredibly useful. By doing so, you can make your data more readable and easier to understand, while still maintaining the accuracy of your calculations.

## Why Enter Data as Thousands?

Entering data as thousands in Excel is a common practice in financial modeling and analysis. This is because it allows you to work with large numbers without having to display all of the digits. For example, if you are working with a revenue figure of \$1,000,000, you can enter it as 1,000 and still maintain the accuracy of your calculations.

By entering data as thousands, you can also make your data more readable and easier to understand. This is particularly important when you are presenting your data to others, as it can help to avoid confusion and make your message more clear.

## How to Enter Data as Thousands in Excel

Entering data as thousands in Excel is a simple process. To do so, you will need to use a custom number format. Here’s how:

### Step 1: Select the Cells You Want to Format

Start by selecting the cells that you want to format. You can do this by clicking and dragging your mouse over the cells, or by clicking on the first cell and then holding down the Shift key while clicking on the last cell.

### Step 2: Open the Format Cells Dialog Box

Next, right-click on the selected cells and choose “Format Cells” from the context menu. This will open the Format Cells dialog box.

### Step 3: Choose the Custom Number Format

In the Format Cells dialog box, click on the “Number” tab and then select “Custom” from the Category list. In the Type field, enter the following format code:

, “K”

This code tells Excel to divide the number by 1,000 and then add the “K” suffix to indicate that the number is in thousands.

### Step 4: Apply the Format

Click “OK” to apply the custom number format to the selected cells. Your data will now be displayed in thousands, with the “K” suffix added to each number.

## Conclusion

Entering data as thousands in Excel is a simple and effective way to make your data more readable and easier to understand. By using a custom number format, you can work with large numbers without having to display all of the digits, while still maintaining the accuracy of your calculations. So the next time you’re working with large numbers in Excel, give this technique a try and see how it can help you to present your data more effectively.

## Related

### All You Need to Know About Capital Bank Account

We discussed about the registered capital contribution requirement under the New Company Law in our previous article. We got some inquiries asking for advice about

### It’s Time to Plan Your Tax Break: How to handle the “6-year rule”

The Individual Income Tax Law (“the IIT Law”) which took effect on 1st January 2019 introduced the “6-year-rule” to determine the tax residency status of