Number format

[dave8]

I have a textbox on a form. The value of this textbox gets transfered to a cell on a worksheet, and the value is expressed as a percentage. For example, when I type, '90' in the textbox, the value should be expressed as 90% on the cell. However, it's displaying 9000%. Here's what I tried:

Range("A1").numberformat = "#.#%"
Range("A1").value = numVariable

also tried:

Range("A1").numberformat = "0.##%"
Range("A1").value = numVariable

also,

Range("A1").value = format(Cint(numVariable),1)


Can anyone help me understand this?

 

[wigi]

Range("A1").value = numVariable / 100
or redefine the variable numVariable.

 

[dave8]

Thank you.