#1   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default rounding in excel

Unless you're specifically rounding the result in the formula, Excel
does not perform any rounding. It does, however, present them onscreen
in a variety of formats. For instance, if your formula is =1/3, the
result is 0.333333333333333333 with the 3 recurring, and Excel is
cognizant of all those recurring threes. What is displayed on screen
depends on how the cell is formatted, whether as a single digit, or
currency, or a fraction, or what. So the answer to your question is
likely to be: from the menu, click Format Cells and select the way
you'd like Excel to present that particular cell.

Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Sharing read-write Excel 2003 files ttt8262 Excel Discussion (Misc queries) 0 April 1st 06 09:39 PM
stop excel from rounding a result Hazeldean Excel Worksheet Functions 3 May 13th 05 10:42 PM
How can I stop rounding in Excel? hutcheeez Excel Discussion (Misc queries) 4 April 1st 05 04:11 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 12:30 AM.

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"