Formatting Combined Cells

Below is what I have in Cells A1 thru A3. I can't seem to get cell A3 to
give me AMKD000415. Instead I keep getting AMKD415. I've tried various
cell formatting with no luck. I would really appreciate any suggestions you
may have. Thanks!

A1
AMKD

A2
000415

A3
=A1&A2

Try this:

=A1&TEXT(A2,"000000")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Betty Csehi" <[email protected]> wrote in message
news:[email protected]...
Below is what I have in Cells A1 thru A3. I can't seem to get cell A3 to
give me AMKD000415. Instead I keep getting AMKD415. I've tried various
cell formatting with no luck. I would really appreciate any suggestions you
may have. Thanks!

A1
AMKD

A2
000415

A3
=A1&A2

=A1&TEXT(A2,"000000")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Betty Csehi" <[email protected]> wrote in message
news:[email protected]...
> Below is what I have in Cells A1 thru A3. I can't seem to get cell A3 to
> give me AMKD000415. Instead I keep getting AMKD415. I've tried various
> cell formatting with no luck. I would really appreciate any suggestions
you
> may have. Thanks!
>
> A1
> AMKD
>
> A2
> 000415
>
> A3
> =A1&A2
>
>

oops, posted before I saw yours RD, wasted.

Bob

"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> Try this:
>
> =A1&TEXT(A2,"000000")
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Betty Csehi" <[email protected]> wrote in message
> news:[email protected]...
> Below is what I have in Cells A1 thru A3. I can't seem to get cell A3 to
> give me AMKD000415. Instead I keep getting AMKD415. I've tried various
> cell formatting with no luck. I would really appreciate any suggestions
you
> may have. Thanks!
>
> A1
> AMKD
>
> A2
> 000415
>
> A3
> =A1&A2
>
>

My fault.
Haven't used this machine for a week and didn't realize the darn clock is
way off.<g>
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Bob Phillips" <[email protected]> wrote in message
news:%23D$QdE%[email protected]...
oops, posted before I saw yours RD, wasted.

Bob

"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> Try this:
>
> =A1&TEXT(A2,"000000")
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Betty Csehi" <[email protected]> wrote in message
> news:[email protected]...
> Below is what I have in Cells A1 thru A3. I can't seem to get cell A3 to
> give me AMKD000415. Instead I keep getting AMKD415. I've tried various
> cell formatting with no luck. I would really appreciate any suggestions
you
> may have. Thanks!
>
> A1
> AMKD
>
> A2
> 000415
>
> A3
> =A1&A2
>
>

Thanks so much. This works fine. I appreciate it!
"RagDyer" <[email protected]> wrote in message
news:[email protected]...
> Try this:
>
> =A1&TEXT(A2,"000000")
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Betty Csehi" <[email protected]> wrote in message
> news:[email protected]...
> Below is what I have in Cells A1 thru A3. I can't seem to get cell A3 to
> give me AMKD000415. Instead I keep getting AMKD415. I've tried various
> cell formatting with no luck. I would really appreciate any suggestions
you
> may have. Thanks!
>
> A1
> AMKD
>
> A2
> 000415
>
> A3
> =A1&A2
>
>