Formatting for Percents

[buckwheat]

I'm sure I asked this question somewhere along the line, but not sure which forum. So I'll present again if ok.



I have a field in my table that I need to format as a percent. . . . seems simple, I have selected Percent as the format and 0 for decimal . . . but instead of results being 85% they are 8500%. . . can anyone advise please?

[RuralGuy]

What actual value in in the field? For it to display 85% the value should be .85

[buckwheat]

That did it . . . thanks much!

[RuralGuy]

Glad we could help.

[buckwheat]

I might not always sound like it, but I really do appreciate the help.

[RuralGuy]

Understood!