Changing Numeric Format in Excel

Asked By cwilson 20 points N/A Posted on - 04/07/2012

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.

• Status: Open
• Question Views: 992
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sherin Viluel

Go To Solution

Answered By ROBLES BONDOC 0 points N/A #101071

Changing Numeric Format in Excel

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.

About ROBLES BONDOC

Questions
0

Answers
15

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 04/07/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Sherin Viluel 0 points N/A #101072

Changing Numeric Format in Excel

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.

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/17/2012
• Question Category: MS Excel