Thread: Fill with zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
rog rog is offline
external usenet poster
 
Posts: 39
Default Fill with zero


Long time since i used this function, but try ;

string$(10-len(yourTextbox.text),"0")

Rgds

Rog


-----Original Message-----
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.
.