The value i enter appears with two decimal places in Excel…

Asked By cullen centeno 10 points N/A Posted on - 04/14/2012

Hi,

When i enter a value it is appearing with two decimal places. For an example when i enter 186 it appears as 1.86. What is wrong and how can i fix?

• Status: Open
• Question Views: 1098
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by sondiapavel

Go To Solution

Answered By sondiapavel 0 points N/A #102615

The value i enter appears with two decimal places in Excel…

You need to format the cell. Please follow the following steps to change the format of cell :

Step 1 :  Right Click on the column where you want to change the format.  Select "Format Cell" from pop-up menu.

Step 2 : Click Number Tab, and select Number under Category, then select Decimal Places : 2 and click OK.

This will solve your problem. Still if you find problem please reply me.

 

 

 

About sondiapavel

Questions
0

Answers
6

Best Answers
2

• Vote Up 0 Vote Down

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

Best Answer

Best Answer

Answered By sondiapavel 0 points N/A #102616

The value i enter appears with two decimal places in Excel…

 

You need to format the cell. Please follow the following steps to change the format of cell :

Step 1 :  Right Click on the column where you want to change the format.  Select "Format Cell" from pop-up menu.

Step 2 : Click Number Tab, and select Number under Category, then select Decimal Places : 2 and click OK.

This will solve your problem. Still if you find problem please reply me.

 

About sondiapavel

Questions
0

Answers
6

Best Answers
2

• Vote Up 0 Vote Down

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

Answered By cullen centeno 10 points N/A #102617

The value i enter appears with two decimal places in Excel…

Great! Is this how it works? please see my image.. Its working now..Formatting cells in Excel is really interesting. Thank you for the solution.

About cullen centeno

Questions
19

Answers
6

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/02/2012
• Question Category: MS Excel