Cell Swallows Decimal Places

Giganews Newsgroups
Subject: Cell Swallows Decimal Places
Posted by:  o…@gmx.net
Date: Wed, 22 Aug 2007

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

Replies