Format to show leading zero

[lehigh46]

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

 

[Luke M]

=TEXT(A5,"000000")&B5

 

[Max]

You can use TEXT, eg:
=TEXT(A5,"0000000")&B5

Above is sync with your sample data which shows 7 digits, not 6
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik

 

[Eduardo]

Hi,
Format column A as a text

 

[David Biddulph]

=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.

 

[Bernard Liengme]

Use custom format: 000000
best wishes