I currently have the problem solved in Excel 2007, but my User will be using 2002, and its telling me my solution isnt compatible.

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