Conversion of 10 digit number into xx-xxx-xx-xxx
Dear Experts:
I got a column of 10-digit numbers. They need to be converted like
this .....
Befo xxxxxxxxxx (10 digits)
After: xx-xxx-xx-xxx (10 digits separated by hyphens)
I would like to run a macro that does this conversion on selected
cells.
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
|