Display zero at the beginning of number in excel cell?

How to display zero (0) at the beginning of any number in excel cell?

Have you ever tried to do this in excel? If you try to add 0 at the beginning of any number in excel cell, that number will disappear and display remaining number. Following is the simple method to display zero at the beginning of any number of fixed length.

If you want three digits fixed length number in any one column. For example 022, 035, 080 in one column follow the below steps:

• Fill that numbers in one column that will look like 22, 35, and 80.
• 
  
  
  
  
• Select column, right click and select format cell as shown below.
• 
  
  
• In number Tab, select Custom.
• 
  
  
• Make type field empty and fill 000 manually in that field.
• 
  
  
• Press OK.