Need to Conditional Format Custom Number

Originally Posted by Casey

Format Cell>Number>Custom
Type in 10 zeros
A cell formated in this manner will display 000000001 when 1 is entered.

HTH

Ok, now how to I do that to a textbox in a user form.

For a long question-

The user form has 20 textboxes
only one of them requires the 10 digit custom format
the number of cells the textboxes post to the sheet varies each time data is inputted and they are offset from the cells above them so formatting all the cells in the column is not an option, and there is no way to know which cell will need the custom format until the data is pasted to the sheet from the Userform.

So, I have one textbox which needs to be formatted to 10 digits so the precededing zeros will show up.
How can I do this so when the textbox is output to Sheet1, the cell it ends up in will retain the custom number format

example:
0847328397