How to add a 0 to the beginning of contact numbers

Modified on Tue, 13 Jul, 2021 at 12:41 PM

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