Quantunet.com

My Account

Joins Us
Excel QuickSkills
Formatting Data Working with decimals Knowledgebase  
How to Set the number of decimal places of a result:
  • Right click on the cell you would like to format
  • Select "Format Cells"
  • In the Dialogue box choose the "Number" tab
  • In "Category" select "Decimal"
Click [here] to see the excel decimals knowledgebase
   

 

This is when you have to be careful as you must be clear if you are to use these results in a second equation check the numerical formatting of the cell otherwise you will accumulate an error in your results.

© 2007 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us