HELP IN A FORMULA
=TEXT(A1,"0000")
"Kashif" wrote:
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.
|