trying to format userform text box to numbers

I have an excel sheet with variables and i am trying to call the variable into the form keeping the format.

current format is #,##0.00 for dolor amounts
and 0.##% for percents

here are two things that i have tried to get the percent to work

Please Login or Register  to view this content.

CR stands for current row
NR next row

As you can see when i call the value i call it as an integer hopping to keep it as a number. it always seems to change to a text string.

thanks

When i try the above code

Please Login or Register  to view this content.

I am still getting state = "8.5%"

and when i push that out to a cell

Please Login or Register  to view this content.

it is being placed as a text value not a number.

you guys are awesome.
the trick that i found was to make sure to set the

Please Login or Register  to view this content.

then it kept it as a number.
Thank you so much I will mark this as answered.