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