Skip to content
Add One Zero Digit in the Front of Number in Microsoft Excel
To add the zero (0) in front of every number using the “Format Cells” option follow the below mentioned steps:
- Select the range of mobile numbers.
- And press the key “CTRL+1” on the keyboard.
- The “Format Cells” dialog box will appear.
- In the “Number” tab select “Custom” from the list.
- In the “Type” box write 0 eleven times.
- Click on ok.