Concatenate String And Date...

mjschukas · Apr 11th 2007

when i concatenate two cells (the word "excel" and today's date), i get
excel 39183...?

i would like: excel 4/11/2007

???

thank you.

**Trebor76** · Apr 11th 2007

Re: Concatenate String And Date...

Hi there,

Simply change the cell references from the following formula to suit:

=A1&" "&TEXT(B1,"m/dd/yyyy")

HTH

Robert
: D

mjschukas · Apr 11th 2007

Re: Concatenate String And Date...

you are wonderfull...!

it's beautiful...thank you.

Participate now!