Format the cell as Text.
Select the RangeDo Right ClickFormat CellsNumberCategoryText and
give ok. Now input your leading zero value in the text formatted range.

But the Values are not treated as real numbers and it is considered as Text
Values.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"zyus" wrote:

When i use formatting cell custom with 0000 i manage to add leading zero but
the problem is the leading zero only as appearance. Is it possible to make it
as value in the cell