- Highlight the column
- Right click and select Format Cells
- On the Number tab, select Custom
- Select the 0 and type 9 zeros – there must be 10 zeros in total
- Click OK
How to add a 0 to the beginning of contact numbers Print
Modified on: Tue, 13 Jul, 2021 at 12:41 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.