You can use =text(location,"00000") this will always put zeroes in front if
needed to make number 5 digits, increase zeroes for more.

-John

"Advent" wrote:

I have looked all over to determine how to maintain leading zeros in a
formula result. I have tried formating cells as custom '0000' and as text to
no avail. I have two cell that I would like to combine into one cell.
Example, b1=60; c1=07 when I combine these two cells I get a1=607... This is
killing me. Any quick help would be greatly appreciated.