Problem entering percentage on form

[Guest]

I have created a form to enter data to a worksheet. I have formatted column
'L' to 'Percentage', but when I enter a number on the form; it multiplies by
100 in the cells. What do I need to do to solve this puzzle?

Thanks for your help,
Joel

 

[Dave Peterson]

What are you typing in the cell? 30 or .30 or 30%

Do you have Tools|Options|Edit tab|"Enable automatic percent entry" checked.

 

[Guest]

I am typing 30, and yes the automatic percent entry is checked

 

[Dave Peterson]

When I have that setting toggled on and the cell is formatted as percentage,
then when I type 30, I see 30.00% (I used percentage with 2 decimal places as
the format.)

I used xl2003 in my test.

 

[Guest]

I am adding the data through a userform, could that somehow be affecting it?

 

[Dave Peterson]

How about doing the arithmetic (divide by 100) in your code?

I am adding the data through a userform, could that somehow be affecting it?