I'm new at using macros in excel and need to prepend zeros to a column of data. i know i'll need an if statement with some kind of loop.
the logic goes something like, select cell, if number is less than 9 digits long prepend "0" until it is equal to 9 digits. if equal to 9 digits do nothing and select next.
can anyone give me some idea as to how the syntax would look like? any help is much appreciated.