VBA Formatting - Userform

Greetings!

I have a user form I am trying to format the output.

With wsInput

        .Columns("A:A").NumberFormat = "General"

        .Columns("B:B").NumberFormat = "mm/dd/yy;@"

        .Columns("E:E").NumberFormat = "mm/dd/yy;@"

        .Columns("J:J").NumberFormat = "$##,##0.00"

        .Columns("K:K").NumberFormat = "$##,##0.00"

        .Columns("C:C").NumberFormat = "0.00"

        .Columns("D:D").NumberFormat = "0.00"

        .Columns("F:F").NumberFormat = "0.00"

        .Columns("G:G").NumberFormat = "0.00"

        .Cells(lngRow, "A") = txtFIN

        .Cells(lngRow, "B") = txtDate

        .Cells(lngRow, "C") = txtDRG1

        .Cells(lngRow, "D") = txtDRG2

        .Cells(lngRow, "E") = txtDCDate

        .Cells(lngRow, "F") = txtW1

        .Cells(lngRow, "G") = txtW2

        .Cells(lngRow, "H") = txtCase

        .Cells(lngRow, "I") = txtCom

        .Cells(lngRow, "J") = txtCost1

        .Cells(lngRow, "K") = txtCost2

I'm not sure what I'm doing wrong.

When I fill in the user form, the numbers are still not formatted.  The data is populating a table, and I have to continually go in and format the numbers in the table.

Can anyone suggest a better way?

Can you tell me what I'm missing here?

Thank you so much!

jules