date and text concatenation

[littleps]

I tried to concatenate cell A1 with date (27.07.2005) and cell B1 wit
text (INVOICE 777) by using formula in cell C1 (=A1&" "&B1)and receive
the following result *38560 INVOICE 777*. But I want to see the resul
as *27.07.2005 INVOICE 777*. How to avoid the date convertion? Pleas
advise. TIA

 

[Odicus]

=TEXT(A1,"dd.mm.yyyy")&" "&B

 

[olasa]

Sure.
=TEXT(A1,"DD.MM.YYYY")&" "&B1

HTH
Ola Sandströ

 

[Max]

Try in say, C1:

=TEXT(A1,"dd.mm.yyyy")&" "&TRIM(B1)

 

[KL]

Hi,

Try this: =TEXT(A1,"dd.mm.yyyy")&" "&B1

Regards,
KL

 

[Bob Phillips]

=TEXT(A1,"dd.mm.yyyy")&" "&B1

--

HTH

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

 

[Max]

You may also wish to browse Debra's page on "Combining Data" at:
http://www.contextures.com/xlCombine01.html
(see especially the section on "Formatting examples" - scroll down)

 

[littleps]

Odicus, Olasa, Max, Bob Philips, KL,

Thanks a lot, it works perfectly. Max tks for the link

 

[Max]

You're welcome (from us <g>) !

It was nice and thoughtful of you to quote
all respondents to your post in your feedback ..
(Appreciated !)