You can do that, but if it is a group, you have to have different condition
for top, right, etc., and you soon exhaust your three conditions.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Yosh" wrote in message
ups.com...
On Feb 7, 3:10 pm, "Bob Phillips" wrote:
Can't be done, and personally I think merged cells are more trouble than
they are worth.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Yosh" wrote in message

ups.com...



On Feb 7, 1:35 pm, "Bob Phillips" wrote:
=A1&TEXT(A2,"mm/dd/yyyy")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Yosh" wrote in message

roups.com...

im trying to concatenate a text and date cell. is this possible?
i.e.
I have one cell that says: Week-ending
And I have another cell: 01/26/2007
Can I concatenate to form: Week-ending 01/26/2007

The problem I have now is the formatting, it keeps taking the date
and
making it a number... (you know what I mean?)

Thanks,

Josh- Hide quoted text -

- Show quoted text -

sweet.
thanks

another question i have...

how to merge cells conditionally???
is there such a thing as =if(A7=1,A7,MERGE(B1:B7))

Thanks,

JB- Hide quoted text -

- Show quoted text -

how about conditionally bordering fo a group of cells?