Saturday, December 10, 2011

How do I make excel in Google docs stop rounding numbers?

I am using excel in google docs to add numbers together. When I input numbers (16.64) it rounds it to 17 so that the final sum is not correct. How do I turn this off?


When I select the individual cell in the formula bar it reads the correct number (16.64).


Thanks!|||Select the whole spreadsheet, and either set the decimal to the desired setting ( DD.cc ), or go into the menu bar, Click on %26lt;Tools%26gt;, then %26lt;Options%26gt;, then the %26lt;Calculations%26gt; tab, then check "Precision as displayed." This will allow for un-rounded answers to be displayed in your worksheet.

No comments:

Post a Comment