Excel 2007 : join cells with 00 values

[maria a]

hello,

i would like to join 3 cells with 00 values

for example:
A1=6050020
B1=00
C1=09

the result that i want to have is a 11 digit number 60500200009

how can i merge these three cells into one?

i tried ampersand but the first zero of B1 and C1 cells is not recognizable.

i would appreciate it if you could help me with this.

thank you!

[Spencer101]

Are the cells formatted at text?
Does the number in B1 show as 00 or 0?

[Cutter]

Try

=TEXT(A1,"000000#")&TEXT(B1,"0#")&TEXT(C1,"0#)

for numeric result

=(TEXT(A1,"000000#")&TEXT(B1,"0#")&TEXT(C1,"0#))*1

actually just this: =(A1&TEXT(B1,"0#")&TEXT(C1,"0#"))*1
and format to show lead 0's if wanted

[maria a]

the number in B1 showed as 0 but i formatted as custom 00

[martindwilson]

=text(a1,"0000000")&text(b1,"00")&text(c1,"00")

[Cutter]

And the result of trying my suggestion is......................??

[maria a]

i'm trying to make this work but the result is 6050020009
missing the the first 0 of B1 cell
i tried to add another 0 to your formula =(A1&TEXT(B1,"00#")&TEXT(C1,"0#"))*1 and it worked
but when i' m trying to drag it down to next row i don;t get the desired result.

here are the next rows and cells

6050020 00 09
9000028 00 00
9000028 02 00
9000028 04 00
9000028 06 00
9000028 10 00

[Cutter]

Sorry, my mistake, use this

=(A1&TEXT(B1,"00")&TEXT(C1,"00"))*1

as suggested by martindwilson in post #5

[maria a]

ok thank you!!

the problem has been solved!!

[maria a]

ok thank you!!

problem solved!

[maria a]

thank you so much!!

[Cutter]

You're welcome so much. Here's hoping your elections tomorrow can solve your country's problems.

[maria a]

You're welcome so much. Here's hoping your elections tomorrow can solve your country's problems.

thank you! we hope also!