shadekitty

How to display a number with a decimal as a percentage

Recommended Posts

I have a chart that contains data similar to

 

.51 and 1.0

 

I would like to display the numbers as 51% and 100%. I know how to add the % suffix, but I cannot determine how to move the decimals over to display the correct percentage. Is this something that I would need to do in the sharepoint list and change how the data itself is displayed for it to properly display in my chart?

 

Thanks!

Share this post


Link to post
Share on other sites

Hi,

 

Sorry for the delay in reply. Yes, its possible. 

 

Please follow the steps given below and see if this works?
 
To show the scaling ranging from 0 to 100:
1. Please open the wizard go to "Number Formatting" 
2. In "Scales to be used" put "%,%" (without quotes) and 
3. In "Values of each Scale" put ".1,.1" (without quotes) 
4. Click on "Apply" and "Finish".
 
I hope this helps.

Share this post


Link to post
Share on other sites

I have an error with this solution. I'm able to get most of my values to show up correctly. (0.152 --> 15.2%). However, values under 10% do not show up correctly in my chart. If the value is under 10% (.10), the value just shows up on the chart without the scaling and % applied. So 0.031 just shows up on the chart as 0.031 instead of 3.1%.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now