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.


Scroll to top
Skip to content