I have columns of phone numbers, some have a leading zero, others are missing their leading zero. The columns are all formatted as 'TEXT' and should remain so.

I need a macro that will look at the selected column and if it already has a leading zero, it does nothing, but if their is no leading zero it adds one to the number (formatted as text), so

0207456789 would remain the same
207456723 would become 0207456723

I have limited VBA knowledge...

Many thanks