Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=A1&TEXT(A2,"000000")
-- HTH RP (remove nothere from the email address if mailing direct) "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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
Thanks so much. This works fine. I appreciate it!
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
split combined Time Date cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |