date with custom text

[Patcheen]

i have a date in f101 in date format 10/6/2016 how do i put custom text in with this but the date has to be first

=F101&" week 10" gives me 42552 week 10

example below is what i need

10/6/2016 week 10

[southward]

Hi,

Give this a try.

=TEXT(F101,"MM/DD/YYYY")&" week 10"

Hope this is helpful.

Cheers

[Patcheen]

Exactly what i needed Thank you

[southward]

Glad I could be of some assistance