Percent from Literal to Readable

[Dr. Evil]

How can I convert data from a number field, .5 for example, to a readable "50%" in another calculation text field?

 

Thanks! 

[Lee Smith]

Is the field type Number or text?

If it is a number field, then you need to use the Inspector and format the field as percent.

[Dr. Evil]

Is the field type Number or text?

If it is a number field, then you need to use the Inspector and format the field as percent.

 

In this case it is not as simple as that. The result of this calculation is to be used as a merge field in a large body of text. This body of text contains, numbers, dates, dollar amounts, etc., and cannot be formatted by inspector.

[Dr. Evil]

I got it to work by flipping it.

 

Start with the readable text field as 50%

and a calculation field w/number result = (percent_readable / 100) resulting in .5

[Lee Smith]

If you only have the one number field, the inspector will format as you wish. If there are other numbers in your merge field, then they all use the one number format. see if this Custom Function helps at all. there are some comments (I didn't read them, but you should).  FormatPercent

[Dr. Evil]

GREAT! Thanks Lee