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″)