The information in this article applies to:
SUMMARYIf you have a pie chart in Microsoft Excel with values displayed in percentage format, you can change the number format. MORE INFORMATIONMicrosoft Excel versions 2.x and 3.0These values represent percentages of values based on a 100-percent scale. The values are in text format. To change any of the values, select the desired value (you will see small squares around the value). Enter the formula bar by pressing F2 and type the new format. For example, if you have an entry such as 25.08% and want to display the integer portion only, enter:
This does not change the way the data has been charted. Microsoft Excel version 5.0By default, Microsoft Excel version 5.0 formats the percenatges as whole numbers. To change the default formatting, follow these steps:
Microsoft Excel version 4.0Microsoft Excel version 4.0 displays percentages as whole numbers by default.Additional query words:
Keywords : |
Last Reviewed: March 15, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |