Forum Discussion
Entering correct cellphone number in excel
Good morning to you all. How do I add the digit "0" in front of a cellphone number? Or alternatively the +27 (for South Africa) in front of a cellphone number Thank you Marié
Select Cellphone number range, then right click format cells, choose custom under type
add country code +27
then ten digits ##########
+27##########
Incase need Zero only then simple replace with 0
add country code +27
then ten digits ##########
+27##########
Incase need Zero only then simple replace with 0
