I have a user form that I can copy over to another worksheet.

With DataSH
    Addme.Offset(0, -1) = DataSH.Range("C6").Value + 1
    Addme.Value = Me.cboSubrecipient
    Addme.Offset(0, 1).Value = Me.txtVIN
    Addme.Offset(0, 2).Value = Me.cboModelYear
However, the data is transferring over as text - and I will need to do calculations on the resulting populated data table. I cannot figure out how to set the resulting text/number in the right format.

Thanks.