Hey John!

I have a workaround that may help you out!

Create a formula field

Your formula is going to be


CONCATENATE(({Percent}*100), “%”)

(replace {Percent} with the actual name of your percentage field)

In english, this formula says


Take this decimal, multiply it by 100, and then create a text string that appends the result of that multiplication with a “%” symbol

You can use this field when creating your automation, and it should correctly format as a percentage in your email

To be clear, the conversion happens in the per cent field; the data is a decimal which is rendered as a percentage in the column. The email system is simply rendering exactly that which is in the field unless you tell it to interpret that field differently as @49erAllie demonstrated.