Number Formatting Help:

Hello,

I am trying to figure out why my number will not format correctly... I have a number thats value is pulled in via external data that gets updated everyday.

Everything works fine there, but I needed the format of that number that was pulled in to have parenthesis around it...

I know that one can add the parenthesis to the number by using the ="("&(Number)&")" function...

What the problem is is that when I add the parenthesis to the number it will not allow me to view it as a percentage; it will leave it as a full general number (Ex. (0.0006), instead of (0.06%)

Is there a way to get the percentage number format back?

Thank You

Thanks that worked Perfectly!!


Regards