# How to Add Zero’s before any Figure in Excel

### Some time it is required to add Zero’s before any number to make it of constant length e.g.

### How it can be done in excel

### Answer

### In Excel it can be done by using simple formula of Text for example

If you want to convert a number to 7 Digit number by adding Zero before it can be don’t this by this formula

If figures are written in coulomb A then past this formula in next coulomb

**=text(A1,”0000000″)**

Add number of zeros between inverted comas that much Digits figure you want to get

If you want to convert **123 à 00123** the its 5 digits figure so formula will become

**=text(A1,”00000″)**