Starting zero erased through VBA form input

[skinfreak]

I have a number input box on a vba form for a telephone number. It works fine to input on a spreadsheet, but it removes the beginning zero e.g.
telephone number "01234 234234" is saved as ""1234 234234".

How can I keep the zero?

 

[ktab]

try to format the destination cell to text

 

[skinfreak]

It works thanks - simple really. I just hope that users don't mess around in the spreadsheet in the future and change it! Thanks

 

[Norie]

How exactly are you transferring the value to the worksheet?

 

[skinfreak]

This is how....

http://www.mrexcel.com/board2/viewtopic.php?t=231401&highlight=

Notice, I've been having some problems....