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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment