LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Cell Swallows Decimal Places

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
appended a cell, but need to keep decimal places [email protected] Excel Discussion (Misc queries) 2 April 11th 07 10:31 PM
decimal places in format cell tom Excel Discussion (Misc queries) 2 February 16th 07 09:07 PM
How many decimal places can a cell display? Spaz Excel Worksheet Functions 10 April 3rd 06 08:33 PM
how to count the number of decimal places in a cell? Warren Smith Excel Worksheet Functions 7 August 28th 05 01:52 PM
How do I insert 2 decimal places to a number in cell? Rebecca Martinez Excel Worksheet Functions 6 July 7th 05 07:12 PM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"