Percent format in table

J

jk

I am trying to have a percent field in my table and i need to use a format
such as 3 percent yet the format option shows 123.00 % . I have tried single
integer and no decimels but it still apears as a field in forms with 000.00
%. How does one configure this?
 
K

KARL DEWEY

Anything less than 100% is a fraction. Three Percent is stored as .03 but if
you store the number 3 then it will display as 300%.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
How to have two tables on same line? 1
Format number field to show Percent 23
Setting column width in a table with a macro is not working 0
Excel does not accept text format! 0
Address Format changed after Migration 0
Doughnut Chart linked with the slicer in the pivot table 0
Macro to copy table of contents to a new doc 0

Top