browser icon
You are using an insecure version of your web browser. Please update your browser!
Using an outdated browser makes your computer unsafe. For a safer, faster, more enjoyable user experience, please update your browser today or try a newer browser.

Changing your Phone Address book

Posted by on August 19, 2008

As you al might know by now the ministry is going to implement their new numbering plan to add a new digit to all numbers in Kuwait, this is a headache for ppl with lots of contacts like myself so i was thinking of a way to automatically do this without having to go through each and every entry in my address book and figure out how it will be changed.

Here is a little excel program i made with the help of my friends to resolve this issue
how it works :

i used microsoft outlook 2003 to sync with my mobile and get all my contacts.
using outlook export the address book to csv ( windows ) file
run the converter if you have high security settings on your excel set to medium to allow you to accept or reject macros.

open your newly created csv file then select the sheet and right click on the tab and select move/copy
select copy then choose the converter.xls as the destination
once its there create another copy inside the converter on the new copy go to the first number cell and replace the content with =CheckNum() then move the cursor between the () and go to the original sheet and click the same field this will take the value from the first sheet and convert it in the new sheet it should look something like this =CheckNum(!Sheet11:A1)
now just drag that cell to cover the other cells/ rows with phones and all your numbers will be converted according to the new plan

to restore :
make the new sheet as the active sheet and goto file / save As / choose to save it as .csv ( comma separated value ) and on outlook select import ( other files ) then choose the new csv file and walllaaa you are set.

-The program will change 6 or 7 digit numbers.
-if the number was longer than 7 digits it will check if it starts with 965 or +965 and apply the changes to result a new 8 digit number without the +965 or 965.
-Program can be used with any list of numbers you need to change ( Personal address books, notes …etc )

Special Thanx to :
Faisal Al-Adwani
Nasser Al-Hilal
For their contributions in this project

if you have any comments/suggestion please feel free to leave them in a comment

9 Responses to Changing your Phone Address book

  1. SweetD

    I thought that they were going to do this last year! So this is really going to happen now?

  2. mjkout

    true they announced this maybe 3 times in the past this time it appears they are serious probably to privide numbers for the new mobile company.

  3. Navy Girl

    changing numbers ?? where ?? whats going in kuwait now ?? i leave and the 2nd day everything is different ! man i’m sure i wont recognize the country when i’m back ;p


    Yeah we will have 8 digit numbers instead of 7 3ad ta3al i7fith wo ghayir again

  5. Navy Girl

    y3ny lazem ragam 6oool elshar3 !! malaga !!!


    Navy: ee shfeech mo shafaw mashro3 el qi6ar be6awil galaw nsawy el arqam 6wal as a demo for el qi6ar

  7. Shoush

    7arakat. i’ll read this post with concentration when october 17 comes. 😛

    BTW, any idea when the new telecommunications sharika will open up and start selling its numbers? And any idea wat number it begins with?


    Shoush: most probably all this mess is to provide the new company with new numbers not sure but i think they will get the 5

  9. Navy Girl

    loooooooooooool 😀

Leave a Reply

Your email address will not be published. Required fields are marked *