View Single Post
  #1   Report Post  
RagDyer
 
Posts: n/a
Default

Try this:

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

HTH,

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


"Betty Csehi" wrote in message
...
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