Percentage format

[Guest]

I have set up a percentage field. I have it formatted as long integer,
percentage, auto for decimal points. Each time I enter a number, say 38, .38
or 38.00 for 38% it defaults to 0. If I enter 3800, it gives me 3800%. I
can;t seem to get the correct format to simply type in 10 and it gives me 10%.

 

[John W. Vinson]

I have set up a percentage field. I have it formatted as long integer,
percentage, auto for decimal points. Each time I enter a number, say 38, .38
or 38.00 for 38% it defaults to 0. If I enter 3800, it gives me 3800%. I
can;t seem to get the correct format to simply type in 10 and it gives me 10%.

A Long Integer is a whole number. Fractional values cannot be stored in a Long
Integer field. 38% isn't a whole number; it's a way of writing the number
0.38.

Change the datatype to Number... Single, Number... Double, or Currency. You
can set the format to percent, and then type either 0.38 or 38% to have it
store 0.38 while displaying 38%.

John W. Vinson [MVP]