Do not round numbers in Excel, turn off rounding in Excel

As you can see in the picture below, the decimal series below has been rounded from 499 to 500.

Do not round numbers in Excel, turn off rounding in Excel Picture 1

You can use the Increase Decimal or Decrease Decimal function in the Number group of the Home ribbon to display the decrease or increase the display after the decimal point.

Do not round numbers in Excel, turn off rounding in Excel Picture 2

The results you can display all the numbers and will not be rounded.

Do not round numbers in Excel, turn off rounding in Excel Picture 3

Or to perform the above function, you can also use another method that is right-clicking on the data box, then selecting Format Cell in the list of options displayed.

Do not round numbers in Excel, turn off rounding in Excel Picture 4

In the Format Cell table , open the Number tab , select Number in the Category field, and then enter the number of numbers after the decimal point you want to display.

Do not round numbers in Excel, turn off rounding in Excel Picture 5

The results you have shown are decimals that are not rounded.

Do not round numbers in Excel, turn off rounding in Excel Picture 6

In case you feel that displaying the entire range makes the width of the data column too long, you can reduce the font size to display the full number range in the area of ​​that data box:

Do not round numbers in Excel, turn off rounding in Excel Picture 7

Or you can choose to follow these steps so that Excel will help adjust the size of your number to fit the size of the data column.

You right-click on the data box, then select Format Cell in the list of display options.

Do not round numbers in Excel, turn off rounding in Excel Picture 8

The Format Cells function window appears, switch to the Alignment tab .

Next, you put a tick on the Shrink to fit line in the Text Control section .

Finally click OK to confirm the settings.

Do not round numbers in Excel, turn off rounding in Excel Picture 9

As a result, your number line will be narrowed to fit the width of the data column.

Do not round numbers in Excel, turn off rounding in Excel Picture 10