Hi

I have a userform and the value produced from a textbox must be be 10
characters long, i.e. if a 3 digit figure is input, is there a way to precede
this figure with seven zeros?

Grateful for all ideas.