Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
appended a cell, but need to keep decimal places | Excel Discussion (Misc queries) | |||
decimal places in format cell | Excel Discussion (Misc queries) | |||
How many decimal places can a cell display? | Excel Worksheet Functions | |||
how to count the number of decimal places in a cell? | Excel Worksheet Functions | |||
How do I insert 2 decimal places to a number in cell? | Excel Worksheet Functions |