How to change decimal places in axis format on Excel graph. Her expertise lies in creating concise and effective guides for common Windows errors, helping readers optimize their Windows devices. Discover Community Next, enter the number you want after the decimal place in the text field for, To add digits to the right of the decimal point, enter a positive number.
Note:Using the Precision as displayed option can have cumulative calculation effects that can make your data increasingly inaccurate over time. I am aware of how to increase or decrease decimals places so it is consistent but not how to display either significant figures or vary the amount of decimal places. By clicking Post Your Answer, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.