Leading Zero

[Sylvan]

Got a UDF I'm working on and I need a variable to contain a leading zero if it's less than 10. For the leading zero I'm trying the following with no success.

i132 = Format(Split(d32, ".")(0),"00")

Any other ideas?

Thanks

 

[Rick Rothstein]

How is the i132 variable declared? It must be either a String variable or a Variant varialbe in order to be able to hold leading zeroes. Your code would should work for either of these type declarations. However, if you end up assigning it to a numeric variable or to a cell formated as General or numeric, then the leading zeroes would be lost (numbers do not have "format" and so they cannot have leading zeroes). You didn't give us enough information as to what is happening, so that is the best I can do for you at the moment.

 

[Sylvan]

It was an integer, changed it to a variant and it works great, thanks!