Copy Paste Formatting??

I have alot of dates that I need to reformat for uploading to a website (Salesforce). I need to take the date and add the time 5PM. They look like this:

Please Login or Register  to view this content.

I need to reformat to this

Please Login or Register  to view this content.

I was able to get the first date part by going to custom format and typing YYYY-MM-DD.

Then I thought I could go into the adjacent cell (say B2) and type =A2 & "T17:00:00PDT"

But the adjacent cell will reformat the date back into this crappy number

Please Login or Register  to view this content.

I need it to read the date as text but I can't format as text or the formula won't work. Is there a way to copy and paste formatting so that a formula will keep the format?