hi I'm new here. I need a solution to this question:

I am trying to combine 4 single cell digits into one set of cell numbers. What I currently have works fine, but when a "0" is used as the first left digit then excel does not use it. How can this be done any help will be greatful.

need this i.e. 0 9 6 7 convents to this "0967" not to this "967"!

http://aycu07.webshots.com/image/499...5208656_rs.jpg