Monday 9 October 2017

How to limit the number of decimal places in an Excel spreadsheet?


For example, I'll have Excel calculate a value based on two other cells, and then have it displayed in another. This is working fine, but how would I limit the number of decimal places it shows?



Answer



Select the output cell, right click and select "Format Cells..."


Select the "Number" tab and then "Number" in the list.


Set the "Decimal places" value to the desired value.


alt text


No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...