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.