Percents rounding - How does it stop?!

[SaraMegan]

Hi. I've searched for this topic, but the only thing I found was from April and had no replies... So here goes:

Anyone know why my percents are rounding? I have a field for TestScore, which should hold a percent... I have the field set up as a number field, Integer, Percent, with Decimal places = 1. I have no default value.

If I type in "87" or "87." (hoping to get 87.0%) I get 8700.0%.

If I type in ".87" I get 100.0%

If I type in ".0087" I get 0.0%

Any thoughts on how to change this to a normal percentage? This is probably super-easy, but (like most things) it baffles me...

Thanks!

--Sara

 

[Rich]

Change the field to single or double

 

[SaraMegan]

Thanks, Rich. I found it... why does that work? What does it do? What do the single and double mean? Is there a way to do it without having to type in the decimal?

--Sara