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é
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
