Microsoft Excel stuck in decimal value

Asked By yasirsiddiqui 0 points N/A Posted on - 09/26/2011

Hi,

I got stuck somewhere in MS Excel. Can you guys please help me? It is a bit urgent.

When I enter a value, it appears with two decimal places. For example, when I enter 154 it shows up as 1.54. What's wrong?

Help please.

Thanks.

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

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Gerard13

Go To Solution

Best Answer

Best Answer

Answered By Gerard13 0 points N/A #129096

Microsoft Excel stuck in decimal value

You can get past through this by formatting the cells. The most common formats for numbers in Excel are percentages and currencies. There are buttons in the Formatting toolbar that can be clicked to change the format of the active cell. The remedy to your problem is also done in the same way. Simply right-click on the active cell that contains your number data and choose the Format Cell option. The first tab is the Number Tab. Click on the General option to set the numbers to a general format. Hope this will help you.

About Gerard13

Questions
0

Answers
5

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/26/2011
• Question Category: MS Excel

Answered By niceguy 0 points N/A #129098

Microsoft Excel stuck in decimal value

To fix the problem perform the following:

1. Open excel

2. This step is dependent on the version of the excel you are using

* excel xp – go to tools -> options

* excel 2001 – go to edit -> preferences

* excel X – go to excel -> preferences

3. Select the edit tab

4. Uncheck Fixed decimal places.

5. Click ok.

Hope this will help. Thanks.

About niceguy

Questions
0

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/30/2011
• Question Category: MS Excel