Hi friends,

I'm doing some housekeeping for my friends & family contact numbers. I want to have a standard prefix for them. The prefix that I want is: +60 (Malaysia Country Code telephone number).

In my worksheet now, I have 3 types of data (phone numbers):

First type: 123456789 (no "+60" prefix)
Second type: 0123456789 (no "+6" prefix)
Third type: 60123456789 and +60123456789 (yes, this is what I want)

My question:

How do I check for all First type & Second type data and add the missing "+60" or "+6" prefix for them?

Note:

In my country Malaysia, standard telefon number is like this: +60123456789 or 60123456789. This happened to me because before this, I recorded this data using cell phone and I just type '0123456789'. When I transfer the contacts to Excel and sync the contacts via some softwares, they ignore zero '0' in front the telephone number, unless I'm saving the telephone number starting by six '6'.

Thank you for your helps guys!