# Rounding to Two Significant Digits in Excel

When working with large sets of data in Excel, it’s important to present the information in a clear and concise manner. One way to do this is by rounding numbers to two significant digits. This not only makes the data easier to read, but it also helps to eliminate any unnecessary information that may be present in the data set.

## Using the ROUND Function

The easiest way to round numbers in Excel is by using the ROUND function. This function takes two arguments: the number you want to round, and the number of digits you want to round to. To round a number to two significant digits, you would use the following formula:

### =ROUND(number,2)

For example, if you have the number 123.456789 in cell A1, you would use the following formula in cell B1:

### =ROUND(A1,2)

This would round the number to 123.46, which is two significant digits.

## Rounding to Two Significant Digits with Custom Formatting

Another way to round numbers to two significant digits is by using custom formatting. This method allows you to display the rounded number without actually changing the underlying value. To do this, you would select the cell or range of cells that you want to format, and then right-click and select “Format Cells”.

In the Format Cells dialog box, select the “Custom” category, and then enter the following format code:

### 0.##

This format code tells Excel to display the number with two significant digits. For example, if you have the number 123.456789 in cell A1, you would select cell A1, right-click, select “Format Cells”, select the “Custom” category, and then enter the format code 0.##. This would display the number as 123.46, but the underlying value would still be 123.456789.

## Conclusion

Rounding numbers to two significant digits is a simple but effective way to present data in Excel. Whether you use the ROUND function or custom formatting, this technique can help to make your data more readable and easier to understand.

## Related

### What You Need to Do Under the New PRC Company Law: Key changes and counter measures

The New PRC Company Law took effect on 1st July 2024, in which some new requirements were introduced for businesses operating in China. We summarized

### What may Trigger Tax Audits? Sharing on Recent Tax Audit Cases

Chinese tax authorities recently strengthened the tax collection efforts, in the face of diminishing fiscal revenues caused by stagnation of the economy. And they also