Hey Guys (and Gals)!

New to the forum but have lurked for a while. Hopefully I can contribute as much as you guys have...guidance from this forum certainly has helped keep my sanity!!! :-p

So, let me start with a question. I've searched but have not found exactly what I'm looking for, maybe its because I'm a VB newbie & may not recognize an answer even it was staring me in the face, lol. Anyway...

I have a UserForm which moves the TextBox values to a data table when a command button is hit. The problem is that the values in the data table then show as text. I need them in numerical form so the pivot tables derived from the data table work properly. The two TextBox formats needed are 1) a normal number (temperature) and 2) a scientific number (ex: 1E-9). So, long story short, I'd like for the user to be able to enter his/her numbers in the TextBoxes & they end up as numbers (without errors) in the data table. Can someone assist me with this?

Thanks in Advance,
Jay