percent format

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

I use Windows XP and Office XP. When I enter a decimal
into a form field that has been formatted as a percent
with decimal places set to auto, it rounds the decimal up
or down (i.e., .56 appears as 100%; .44 appears as 0%).
If I enter the number as 5.6, the result is 600%; if I
enter the number as 56, the result is 5600%. What's going
on and how do I fix it?
 
Sounds like you have data type set to integer. You should set it to double
if you are using decimal places. Integer is for whole numbers. 1 is 100%,
2 is 200%, etc.

Kelvin
 
Back
Top