You don't necessarily need a formula to do this. You can format the numbers
to *display* as 0015 and 0777.

Select the range of cells in question.
Goto FormatCellsNumber tab
Select: Custom
Under Type enter 0000
OK out

Note that Excel does not recognize leading zeros in numbers. The true
underlying values will still be 15 and 777.


--
Biff
Microsoft Excel MVP


"Kashif" wrote in message
...
I have a column with two digit & three digit values e.g. 15, 777 which i
want
to convert in four didgit value in next column as 0015, 0777.
Can i use a formula in the column that adds no of ZEROs in the value
bringing it in a FOUR DIGIT VALUE?

I hope my question makes sense. Any help will be greatly appreciated.