Format to show leading zero
 

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

Format to show leading zero
 

=TEXT(A5,"000000")&B5
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"lehigh46" wrote:

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

Format to show leading zero
 

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
---
"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

Format to show leading zero
 

Hi,
Format column A as a text

"lehigh46" wrote:

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

Format to show leading zero
 

=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

Format to show leading zero
 

Use custom format: 000000
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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