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" wrote in message
...
oops, posted before I saw yours RD, wasted.
Bob
"RagDyer" wrote in message
...
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
|