len("string")
works either in a worksheet or a VBA function


-----Original Message-----
I need a macro that will look at a cell and if it only
has one character then add zero's in front of it until it
has 3 characters.

Example: if cell "A1" = "10" then the macro would make
it say "010"
if cell "A1" = "BA" then the macro would
make it say "0BA"

Is there a setting that looks at the number of
characters???

Thanks,
Kevin

.