Microsoft Excel stuck in decimal value

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

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.

SHARE
Best Answer by Gerard13
Best Answer
Best Answer
Answered By 0 points N/A #129096

Microsoft Excel stuck in decimal value

qa-featured

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.

Answered By 0 points N/A #129098

Microsoft Excel stuck in decimal value

qa-featured

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.

Related Questions