Problem entering percentage on form
 

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

Problem entering percentage on form
 

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

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



Jase4now wrote:

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

Problem entering percentage on form
 

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

"Dave Peterson" wrote:

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

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



Jase4now wrote:

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

Problem entering percentage on form
 

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.

Jase4now wrote:

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

"Dave Peterson" wrote:

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

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



Jase4now wrote:

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


--

Dave Peterson

Problem entering percentage on form
 

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

"Dave Peterson" wrote:

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.

Jase4now wrote:

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

"Dave Peterson" wrote:

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

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



Jase4now wrote:

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


--

Dave Peterson

Problem entering percentage on form
 

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

Jase4now wrote:

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

"Dave Peterson" wrote:

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.

Jase4now wrote:

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

"Dave Peterson" wrote:

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

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



Jase4now wrote:

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


--

Dave Peterson


--

Dave Peterson