How to make a macro who will check one entire column (etc. A) for numbers
with 4 digits and less and change it to a 5 digits numbers.

Example:

499 to 00499
1480 to 01480

and 5 digits number leave unchanged.


Thanks!