#1   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Rounding Issues

Niek,

Thanks for the quick response, works great!!

"Tim" wrote:

Can someone guide me on how to turn off the rounding feature within Excel.
I've got Office 2007 and it appears that this is the default setting.
Example, I select quotient option and it states that it "Returns the interger
portion of a division". If I divide 22.5 by 3.05 it returns the interger
portion of the division which is 7 - I want to get 7.37. I have tried most of
the help topics on this, but still can't get it to work. Is it a setting or
could it be the way in which I am entering the data?

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
I need a formula with rounding up & rounding down to the nearest . Tony Kay Excel Worksheet Functions 3 May 29th 07 11:13 PM
Scrolling Issues Loretta Excel Discussion (Misc queries) 1 January 22nd 07 02:03 AM
Financial Stmt rounding issues Jeanne Excel Worksheet Functions 1 May 5th 06 06:45 PM
rounding issues [email protected] New Users to Excel 1 February 27th 06 09:16 PM
Rounding Issues Louis Excel Discussion (Misc queries) 1 February 4th 05 10:23 PM


All times are GMT +1. The time now is 12:53 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"