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
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
Last edited by Patcheen; 07-17-2016 at 04:11 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks