modifying numbers

hi developers,
my country will modify all mobile phones numbers adding to them one more digit number after first numbers , because the increment of mobile phones holders
i got over 600 numbers in my mobile phone .. after syncing and importing at Microsoft Excel ,, i need help with a way (find & replace or Function ) to modify and to add a number to all other numbers
for ex. how to modify all the numbers starting with 024#### to 0240#### ,,,
.. waiting for geek's help

Hi
If your phone numbers are formated to text with leading zeros and the first 3 numbers are 024 and you want to add a 0 after that, then the following formula should work if you drag it down alongside you telephone numbers.

=CONCATENATE(LEFT(A3,3),0,RIGHT(A3,LEN(A3)-3))

In this example the list of numbers begins in A3.

Originally Posted by DBY

Hi
If your phone numbers are formated to text with leading zeros and the first 3 numbers are 024 and you want to add a 0 after that, then the following formula should work if you drag it down alongside you telephone numbers.

=CONCATENATE(LEFT(A3,3),0,RIGHT(A3,LEN(A3)-3))

In this example the list of numbers begins in A3.

thanks so much DBY it worked as u clarified ,, but i changed the ( , ) with ( ; ) in all the function to work
thanks once again

@ snb
Will that work for transferring to a mobile phone ?