Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
I am very sorry about your issues. The default decimal digits in Excel is 2 for data of type Percentage. So in your example, Excel may show only 3.67% but the actual value used in your computation is your actual input which is 3.666667%.
If you want to show all the decimal digits that you enter, all you have to do is adjust the number of decimals to a fix number like 5 or 6.
Here are the steps to do this:
I hope that helped.Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!
If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.