Cell Swallows Decimal Places

O

ojh

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
 
B

Bob Phillips

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)
 
O

ojh

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
 
O

ojh

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
 
C

challa prabhu

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
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top