Can you change the # of places for percentages in xcel charts
I have some data that = less than 1% of the total amount, and want to display
it as 0.xxx instead of "0" percent. Is there a way to change the percentage format to include more than one # place? |
Can you change the # of places for percentages in xcel charts
Hi,
Select the cells you want formatted and click the Increase Decimals button on the Formatting toolbar as many times as necessary. -- Cheers, Shane Devenshire "Headmistress05" wrote: I have some data that = less than 1% of the total amount, and want to display it as 0.xxx instead of "0" percent. Is there a way to change the percentage format to include more than one # place? |
All times are GMT +1. The time now is 08:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com