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