is there a way to ouptup a number as a percent to Excel

[Brad1]

is there a way to ouptup a number as a percent to Excel?  Example .15 to 15%,

[CharlieS · Accepted solution]

Since the "%" character isn't a numeric value, this will have to be made as a string field. If the original field is called [Percent], create a new field (formatted as a string) using this formula:

tostring(([Percent]*100),0)+"%"

[Brad1]

How do I get 1 sig fig to the right of the decimal point?

[Brad1]

Did you adjust the formula to this: 

tostring(([Percent]*100),0)+"%"

if so I get a Malformed Function Call

[Brad1]

Oh, never mind.  I guess it only works if you type the formula correctly.

[CharlieS]

Haha we've all been there. I did update the formula with the ",0" to specify 0 decimal places.

I'm glad the formula worked. Happy Alteryx-ing!