Entering correct cellphone number in excel

Copper Contributor

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é

2 Replies
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

@sivakumarrj 

 

thanks very much