Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I am trying to apply % for a chart where result is between 0.00 to 0.99 and would like to display as %
When I apply number format it displays as 66.66% or so on. i want it to be 0.66% instead. Can you please suggest the number format
I used ##.00% and few others but dint work.
Thanks,
S
Hi,
Divide the number by 100 and you will get the expected result.
Regards,
Jagan.
Hi,
Please check this. Thank you.
Or you can just add '%' to the number:
Hi SV,
Did you able to manage to get the solution? Thank you.
Hi
First Divide your expression by 100
than Go to Number Tab option > Select the Expression on which you want to show
the Percentage Sign (%) and Select Fixed to option and Check Show in Percent (%) option.
See this:
Regards
Av7eN