# How to Stop Rounding in Excel: 5 Handy Ways

## Method 1 – Increasing Column Width to Stop Rounding in Excel

Steps:

• Place your cursor at the border of the column index, and it will turn into a double-pointed arrow. After double-clicking, the column will be automatically fitted with the number.

Here is the result,

## Method 2 – Changing Cell Format from General to Number to Stop Rounding

Steps:

• Select the cell. Go to the Home tab. Click on the Number group. Select the Number option.

• You will see the result without scientific format but with two decimal-place figures.

• To remove these decimal places, go to the Home tab, click on the Number group, and click on the Decrease Decimal button, as in the following image.

## Method 3 – Converting Number to Text Format in Excel

Steps:

• Select your cell. Go to the Home tab. Click on the Number group, and select the Text option from the drop-down menu.

• Type your required number at whatever length you want. Excel will not round it off.

## Method 4 – Increasing Decimal Places to Stop Rounding

Steps:

• Under the Home tab, click the Number group. Click the Increase Decimal button, shown in the following image, until your desired number appears with all the digits.

## Method 5 – Formatting Number to Currency

Steps:

• After selecting the cell that contains your number, go to the Home tab and click on the Number group. Select the Currency number format.

• If you want to remove the decimals, click the decrease decimal button until all the decimals vanish.

<< Go Back to Rounding in Excel | Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Hafizul Islam

Hafizul Islam is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF