percent format

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?
 
K

Kelvin Lu

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
 

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

Top