=TEXT(A1,"000000")&B1
Note that I have used a 6 digit number, as you requested, not a 7 digit
number as in your example. Adjust the formula to suit.
--
David Biddulph

"lehigh46" wrote in message
...
Hi All:

Column A has 6 digit equipment numbers, some with leading zero's. (The
cells are formatted to show leading zero's)
Column B has 3 digit month names.

In column C I want to concatinate A & B

ie; 0400051 FEB 0400051FEB

When I type in the formula =A5&B5 the leading zero is gone.
How can I keep it desplayed?

Thanks for your help.

Tom