Changing Numeric Format in Excel

Asked By 20 points N/A Posted on -
qa-featured

Hi tehcyv.

I have this problem I have been encountering while making my work in Excel.

Everytime I input a whole number into the cell, it became a decimal format with 2 decimal places on it.

How will I solve this problem?

Thanks.

SHARE
Best Answer by Sherin Viluel
Answered By 0 points N/A #101071

Changing Numeric Format in Excel

qa-featured

Hi cwilson! Your problem is primarily because of the number setting of your cell. To change the setting of a cell, just put the cursor on the cell you want to format and then Right click. Choose Format cells. A pop-up Format Cells box will then appear. Go to Number tab and click on the category Number.

From there you can modify the decimal places you prefer. You can also modify the format for negative figures. If you want to apply the same setting to more than one cell, select the area of the cell you want to format and do the steps as instructed above.

Best Answer
Best Answer
Answered By 0 points N/A #101072

Changing Numeric Format in Excel

qa-featured

In your excel sheet the cells which you enter whole numbers may have formatted to two decimal places. Therefore you will have to change the decimal places to zero of the relevant cells in order to overcome this problem.

There are two methods that you can follow to change the decimal place.

Method 1

·         Select the area of cells that you enter the whole numbers.

·         Then right click on the selected area and click on the format cell.

·         Then click on the number tab and click on the number field.

·         Now change the decimal places in to “0” and click ok.

Method 2

·         Select the area of cells that you enter the whole numbers.

·         Then click on the home tab and select the number format in the number section (see “I” on the image).

·         After click on the comma (see “II” on the image) and click continuously on the decrease decimal (see “III” on the image) until all the decimals are removed.

Related Questions