I have to work on an Excel sheet that someone else prepared and it
behaves differently than any worksheet I've seen: If I enter a number
wirh multiple decimal places, the number is rounded to one decimal
place not only for displaying but also for internal storage
apparently, which causes rounding errors. (The formatting is set to
percent with one decimal place.)

I would like it to store all decimal places internally (and have them
displayed when editing the cell) but only display one decimal place
which is how a "fresh" worksheet behaves and how I thought Excel
"normally" works.

Is there a setting I'm missing or what else can be the cause of this?

Thanks
Oliver

Sounds as though there is worksheet event code changing it.

Right-click on the sheet tab, select 'the View Code option from the menu,
and see if there is code doing it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have to work on an Excel sheet that someone else prepared and it
> behaves differently than any worksheet I've seen: If I enter a number
> wirh multiple decimal places, the number is rounded to one decimal
> place not only for displaying but also for internal storage
> apparently, which causes rounding errors. (The formatting is set to
> percent with one decimal place.)
>
> I would like it to store all decimal places internally (and have them
> displayed when editing the cell) but only display one decimal place
> which is how a "fresh" worksheet behaves and how I thought Excel
> "normally" works.
>
> Is there a setting I'm missing or what else can be the cause of this?
>
> Thanks
> Oliver
>

> Sounds as though there is worksheet event code changing it.

> Right-click on the sheet tab, select 'the View Code option from the menu,
> and see if there is code doing it.

I've checked, but there is not event code (other than Workbook_Open,
but I wrote that).

Oliver

I've found it, in case anyone cares:

There's a checkbox Tools > Options > Calculation > Accuracy As
Displayed (or something like that, I'm re-translating from the German
version) that causes this behaviour.

Thanks anyway
Oliver

Hi,

Do the following:

1. On the Tools menu, click Options. the Options dialog box is displayed.
2. Click the claculations tab.
3. Under the Windows Options, select the Precision as displayed check box.
4. Click the Edit tab.
5. Under the Setting, select the Fixed decimal checkbox, and click the up or
down arrow to specify the number decimal places you for that values in the
cell.
6. Click Ok to save the settings and return to the active worksheet.

Challa Prabhu

"(E-Mail Removed)" wrote:

> I have to work on an Excel sheet that someone else prepared and it
> behaves differently than any worksheet I've seen: If I enter a number
> wirh multiple decimal places, the number is rounded to one decimal
> place not only for displaying but also for internal storage
> apparently, which causes rounding errors. (The formatting is set to
> percent with one decimal place.)
>
> I would like it to store all decimal places internally (and have them
> displayed when editing the cell) but only display one decimal place
> which is how a "fresh" worksheet behaves and how I thought Excel
> "normally" works.
>
> Is there a setting I'm missing or what else can be the cause of this?
>
> Thanks
> Oliver
>
>

Regardless of the advice Challa has given you here, do *NOT* set Tools/
Options/ Edit/ Fixed decimal places, unless you want Excel to change the
values you type in. With that option set to 2 decimal places, if you type
in 12345, then the value in the cell will become 123.45.

Also, Challa seemed to be suggesting turning *ON* the "Precision as
displayed" option, but I believe that the answer to the OP's question is to
turn *OFF* that option.
--
David Biddulph

"challa prabhu" <(E-Mail Removed)> wrote in message
news:BC141624-8FA5-45EF-8BED-(E-Mail Removed)...
> Hi,
>
> Do the following:
>
> 1. On the Tools menu, click Options. the Options dialog box is displayed.
> 2. Click the claculations tab.
> 3. Under the Windows Options, select the Precision as displayed check box.
> 4. Click the Edit tab.
> 5. Under the Setting, select the Fixed decimal checkbox, and click the up
> or
> down arrow to specify the number decimal places you for that values in the
> cell.
> 6. Click Ok to save the settings and return to the active worksheet.
>
> Challa Prabhu

> "(E-Mail Removed)" wrote:
>
>> I have to work on an Excel sheet that someone else prepared and it
>> behaves differently than any worksheet I've seen: If I enter a number
>> wirh multiple decimal places, the number is rounded to one decimal
>> place not only for displaying but also for internal storage
>> apparently, which causes rounding errors. (The formatting is set to
>> percent with one decimal place.)
>>
>> I would like it to store all decimal places internally (and have them
>> displayed when editing the cell) but only display one decimal place
>> which is how a "fresh" worksheet behaves and how I thought Excel
>> "normally" works.
>>
>> Is there a setting I'm missing or what else can be the cause of this?
>>
>> Thanks
>> Oliver