Numbers are tranfered from userform as text

Hello

I use this code to transfer from a userform with 15 textboxes to sheet11-starting in columnB,all the info that user type in these boxes.

Please Login or Register  to view this content.

In some of these textboxes(2,5,11,12,13) we type numbers.

My problem is that in sheet 11 that data are trensfered, as text. Not as numbers!

Does anyone has an idea how to fix this?

Thanks in advance for any assistance!

Multiply your value or text value by 1

Please Login or Register  to view this content.

It will not work for textbox with text in it I think

Maybe add

Please Login or Register  to view this content.

Thank you for your reply.

Please Login or Register  to view this content.

This gives me an error.

Please Login or Register  to view this content.

Originally Posted by Sbarro79

It will not work for textbox with text in it I think

Maybe add

Please Login or Register  to view this content.

Yes. That's works great.

Thank you!