I have a field that contains a "percentage". I get data from several outside sources to populate this field. The rub is I need to format this field to read correctly as a percentage example 55% or 100%. The data come from outside sources as follow 100, 100%, 100.00 or sometime 1. Another example 55, 55%, 55.00, & .55.I would need this to all be one format with a condition, but I am having a hard time figuring out how to do this. I am sure it is easy but I am stumped. 

It's not as easy as you may think.  For example, what happens when you get .55.  Do you know they meant 55% or is it .55%?  Also, how do you know 1 means 100% and not 1%?

If it's always going to be whole numbers, it makes it easier.

What's the 'outside sources' ?  Can the formatting get fixed there first?  Can the formatting be fixed before import?

Edited April 16, 20187 yr by Steve Martino

For my purposes I use auto entry calculation which says

 case( x=>1,x/100,x)  and format as percent. With caveat this fails if there are ever anticipated results of less than 1